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