TXT to Excel help.

marc512 · 18 Nov 2009 at 11:36

In a previous version of excel i could paste txt files into the spreadsheet and it will sort itself into rows and columns. Now it doesnt

as you can see the words with, represent a row, that should make excel sort itself out etc but it doesnt

any help?

PMWD · 18 Nov 2009 at 12:20

Have you tried saving it into a txt file but giving it the extension .csv and then opening with Excel?

GravyMonster · 18 Nov 2009 at 13:46

The above will work, or you can go to Open in Excel and choose TXT filetype. When you select your file it'll take you through a wizard to determine the field/column delimiters etc.

Malakite · 18 Nov 2009 at 13:57

Can't see the picture due to dodgy work comp atm but in the data menu in excel there is the "Text to Columns" option that lets you split the data based on the delimiter or manual marks you wish.

Mark M · 18 Nov 2009 at 16:22

As above, text to colums is your friend