一、目标:来看一下我们要达到的效果
二、方法一:CTRL+E智能填充
拆分前的内容
拆分后的内容
-0.1889 5.74778 39.91068 10.04161
-0.1889
5.74778
39.91068
10.04161
-0.1889 5.74878 39.91046 10.04083
-0.1889
5.74878
39.91046
10.04083
-0.1889 5.74978 39.91025 10.04005
-0.1889
5.74978
39.91025
10.04005
-0.1889 5.75078 39.91003 10.03927
-0.1889
5.75078
39.91003
10.03927
-0.1889 5.75178 39.90981 10.03848
-0.1889
5.75178
39.90981
10.03848
-0.1889 5.75278 39.90959 10.03770
-0.1889
5.75278
39.90959
10.0377
-0.1889 5.75378 39.90938 10.03692
-0.1889
5.75378
39.90938
10.03692
-0.1889 5.75478 39.90916 10.03614
-0.1889
5.75478
39.90916
10.03614
-0.1890 5.75578 39.90894 10.03535
-0.189
5.75578
39.90894
10.03535
-0.1890 5.75678 39.90872 10.03457
-0.189
5.75678
39.90872
10.03457
-0.1890 5.75778 39.90851 10.03379
-0.189
5.75778
39.90851
10.03379
将第一条的信息手动复制拆分成三列(打样),用鼠标选中第二条信息的拆分单元格,然后按CTEL+E自动填充第二条信息后的内容。
拆分前的内容
拆分后的内容
-0.1889 5.74778 39.91068 10.04161
-0.1889
5.74778
39.91068
10.04161
-0.1889 5.74878 39.91046 10.04083
-0.1889 5.74978 39.91025 10.04005
-0.1889 5.75078 39.91003 10.03927
-0.1889 5.75178 39.90981 10.03848
-0.1889 5.75278 39.90959 10.03770
-0.1889 5.75378 39.90938 10.03692
-0.1889 5.75478 39.90916 10.03614
-0.1890 5.75578 39.90894 10.03535
-0.1890 5.75678 39.90872 10.03457
-0.1890 5.75778 39.90851 10.03379
拆分前的内容
拆分后的内容
-0.1889 5.74778 39.91068 10.04161
-0.1889
5.74778
39.91068
10.04161
-0.1889 5.74878 39.91046 10.04083
-0.1889
-0.1889 5.74978 39.91025 10.04005
-0.1889
-0.1889 5.75078 39.91003 10.03927
-0.1889
-0.1889 5.75178 39.90981 10.03848
-0.1889
-0.1889 5.75278 39.90959 10.03770
-0.1889
-0.1889 5.75378 39.90938 10.03692
-0.1889
-0.1889 5.75478 39.90916 10.03614
-0.1889
-0.1890 5.75578 39.90894 10.03535
-0.189
-0.1890 5.75678 39.90872 10.03457
-0.189
-0.1890 5.75778 39.90851 10.03379
-0.189
三、方法二:数据-分列
拆分前的内容
拆分后的内容
-0.1889 5.74778 39.91068 10.04161
-0.1889
5.74778
39.91068
10.04161
-0.1889 5.74878 39.91046 10.04083
-0.1889
5.74878
39.91046
10.04083
-0.1889 5.74978 39.91025 10.04005
-0.1889
5.74978
39.91025
10.04005
-0.1889 5.75078 39.91003 10.03927
-0.1889
5.75078
39.91003
10.03927
-0.1889 5.75178 39.90981 10.03848
-0.1889
5.75178
39.90981
10.03848
-0.1889 5.75278 39.90959 10.03770
-0.1889
5.75278
39.90959
10.0377
-0.1889 5.75378 39.90938 10.03692
-0.1889
5.75378
39.90938
10.03692
-0.1889 5.75478 39.90916 10.03614
-0.1889
5.75478
39.90916
10.03614
-0.1890 5.75578 39.90894 10.03535
-0.189
5.75578
39.90894
10.03535
-0.1890 5.75678 39.90872 10.03457
-0.189
5.75678
39.90872
10.03457
-0.1890 5.75778 39.90851 10.03379
-0.189
5.75778
39.90851
10.03379
选中所有要拆分的内容,执行“数据-分列-分列”
在弹窗中点击下一步选择相应选项(注意一定要选对分隔符),预览是否正确,点击完成。
四、方法三:数据-智能分列
选中所有要拆分的内容,执行“数据-分列-智能分列”
在弹窗中点击下一步选择相应选项,预览是否正确,点击完成即可拆分完成