在excel中复制乱码列文本(Copying garbled column text in excel)

在excel中复制乱码列文本(Copying garbled column text in excel)

我有一些以逗号分隔的列格式数据

name1,age1,school1,subjects1,location1,dob1,doj1 name2,age2,school2,subjects2,location2,dob2,doj2 name3,age3,school3,subjects3,location3,dob3,doj3

有些像白色空间隔开

name4,age4,school4,subjects4, location4,dob4, doj4 name5,age5,school5, subjects5,location5,dob5,doj5

如何在excel Sheet中的单独列中正确复制粘贴它们。 我尝试使用textpad ，通过复制它，然后用空格替换逗号，然后选择块选择模式并单独复制每个列，然后粘贴它。 但是过程过于繁琐且耗时。

I have some data coming in column format separated by commas

name1,age1,school1,subjects1,location1,dob1,doj1 name2,age2,school2,subjects2,location2,dob2,doj2 name3,age3,school3,subjects3,location3,dob3,doj3

some are like this separated by white spaces

name4,age4,school4,subjects4, location4,dob4, doj4 name5,age5,school5, subjects5,location5,dob5,doj5

How can i copy paste them correctly in separate columns in excel Sheet. I have tried doing this using textpad , by copying it and then replacing the comma by blank space and then selecting the block select mode and copying each column seperately and then pasting it. But process is too cumbersome and time taking.

最满意答案

这很容易做到。 选择文本并转到数据 - >数据工具 - >文本到列。 然后选择“分隔”选项并按NEXT。 之后，勾选“逗号”和“空格”并按完成。 它将在单独的列中执行所有操作。

It is very easy to do. Select your text and go to Data --> Data Tools --> Text To columns. Then select "Delimited" option and press NEXT. Afterwards, tick "comma" and "space" and press finish. It will do everything in a separate column.