Hi. I opened a text file in Excel and saved it as a csv file. Now I need to export/save it back to a text file but I need to save it so that it does not save the columns - in other words, each line of data is currently in a separate column in the csv file - I need to revert to a file in which all that data is in the A column so that I get this in the saved txt file

AC#10,4R-JUH,90%,WEEK,IFR,2/02:52:48,2/08:21:20,540,R,0000,OETF,2/09:26:33,2/14:55:05,180,R,0000,VCBI



instead of this:

AC#10 4R-JUH 90% WEEK IFR 2/02:52:48 2/08:21:20 540 R 0 OETF 2/09:26:33 2/14:55:05 180 R 00000 VCBI

I used the data tab to import the text file and have the separate data, between commas, appear in separate columns, but I just cannot get it to revert to all data in column A, (then export to text so as to have the 1st example).. I thought a comma separated file, instead of a tab separated would do that, but I have wasted an hour so far with no luck!!

Thanks for any help,

Martin

Hi Martin,

A CSV file is a Comma-Separated Values file. If you simply save your CSV file as a:
• TXT file (via File|Save As), you'll get tabs instead of commas.
• PRN file (via File|Save As), you'll get spaces instead of commas.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

So there's no way to get the commas back, as in my example? This is for a gaming programme file and syntax is important. No commas, no file....

Thanks,

Martin

If you have a CSV file, it will alreay have the commas in it. You should be able to see these if you open it with a text editor - not with Excel. If you want to be able to open it in Excel and see the commas, change the file's extension from CSV to TXT.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Haha!! Just change the file extension! That works. Thanks a lot,

Martin