怎样分离一个excel表格数据，我所有数据在一个表格里面，怎样分开？
发布网友
发布时间：2022-04-23 16:35
共3个回答
热心网友
时间：2023-10-09 12:44
因为你的数据都在同一个单元格里面且数据长度不一,用公式可以做,但很麻烦
复制到word里替换成如下形式
再把数据复制到excel里按固定宽度分列就很容易了
japangermanyUKUSAjapangermanyUKUSA
195717.8199175.919576.2195714.41957108581957216.4195722.11957461.1
195817.8199279.819586.4195814.81958115381958231.2195823.051958467.1
195917.9199383.319596.4195914.91959131901959250.4195924.351959506.6
196018.6199485.619606.5196015.21960160101960302.5196025.981960526.5
196119.6199587.119616.7196115.31961193361961331.6196127.411961544.8
196220.9199688.319627196215.51962219431962360.8196228.711962585.6
196322.519979019637.1196315.71963251131963382.8196330.411963617.8
1923.41990.8197.41915.9192954119419.81933.2319663.6
196524.9199991.319657.7196516.11965328661965458.2196535.1965719.1
196626.2200092.719668196616.619663817019687.7196638.191966787.7
196727.2200194.519678.2196717.11967447301967494.2196740.281967832.4
196828.7200295.819688.6196817.81968529751968533.6196843.6619609.8
196930.2200396.819699.1196918.81969622291969597.6196947.021969984.4
197032.5200498.519709.7197019.91970733451970705.3197051.719701038.3
197134.62005100197110.6197120.71971807011971782.8197157.6719711126.8
197236.32006101.6197211.3197221.41972923941972853.51972.6219721237.9
197340.52007103.9197312.4197322.719731124981973950.6197374.5419731382.3
197449.92008106.6197414.3197425.3197413424419741028.8197484.5119741499.4
197555.72009107197517.8197527.6197514832719751077.71975106.7219751637.7
1976612010197620.7197629.1197616657319761168.41976126.2719761824.6
1977661977241977311977185622197712451977146.9719772030.1
197868.7197826197833.4197820440419781327.91978169.3419782293.7
197971.3197929.5197937.2197922154719791442.21979199.2219792562.2
198076.8198034.8198042.2198024283919801542.21980233.1819802788.1
198180.6198139198146.5198126106819811615.11981256.2819813126.8
198282.8198242.3198249.4198227408719821682.41982281.0219823253.2
198384.4198344.3198351198328505819831756.91983307.2119833534.6
198486.3198446.4198453.2198430297519841842.41984329.9119843930.9
198588.1198549.3198555.1198532540219851925.31985361.7619854217.5
198688.6198651198656.1198634055919862028.419863.15198460
198788.7198753.1198758.2198735417019872083.21987428.6619874736.3
1988.3198855.7198860.61988380743198821971988478.5119885100.4
1991.319601963.519410122192348.319525.27195482.1
199094.1199065.7199066.9199044278119902555.61990570.2819905800.5
199197.2199169.5199169.7199146942219913001.41991598.6619915992.1
199298.9199272.1199271.8199248078319923220.51992622.0819926342.3
1993100.1199373.3199374199348371219933313.91993654.219936667.3
1994100.8199475.1199475.9199448845019943482.91994692.9919947085.1
1995100.7199577.6199578199549516519953615.21995733.2719957414.6
1996100.8199679.5199680.3199650501219963669.51996781.7319967838.5
1997102.6199782199782.21997515419973746.51997830.0919978332.3
1998103.3199884.8199883.5199850490519983843.91998879.119988793.5
1999102.9199986.2199985.3199949762919993925.71999928.7319999353.5
2000102.2200088.7200088.2200050299020004034.52000976.5320009951.5
2001101.4200190.3200190.7200149772020014138.920011021.83200110286.2
2002100.5200291.8200292.1200249131220024198.520021075.562002102.3
2003100.3200394.4200394.2200349029420034237.920031139.75200311142.2
2004100.3200497.2200496.7200449832820044310.120041202.96200411867.7
200510020051002005100200550173420054378.120051254.06200512638.4
2006100.22006103.22006103.22006507365200551.520061328.36200613398.9
2007100.32007107.62007106.22007515520200747.320071404.84200714061.8
2008101.72008111.92008110.2200850511420084846.220081445.58200814369.1
2009100.32009111.32009109.9200947421920094684.220091394.99200914119.1
201099.62010116.52010111.720104876.920101453.622010
热心网友
时间：2023-10-09 12:44
选中这列，数据-分列-分隔符号，空格勾上，其他里面输入一个西文句号.
完成
热心网友
时间：2023-10-09 12:45
希望能将问题再详细一点，这样看得不是很明白。
你说的在一个表格内，是指的同一个sheet还是不同一个呢？相信想帮助你的人都需要更详细的描述
