Export XLS to TXT will Comma separator

  • Thread starter Thread starter ilham
  • Start date Start date
I

ilham

Hello,

I'd like to export/save Excel file into a text file. The result I wan
is something like this,

OWNER,ROOMNUMBER,TELNUMBER,DEPARTMEN

instead of like this when saving in Text (MS-DOS), CSV (MS-DOS) etc,

OWNER ROOMNUMBER TELNUMBER DEPARTMEN

FYI, I tried a few Save As Type options there is but does not seem t
work.

Is there a way doing this without having to do any programming?


Regards,

ilha
 
When you saved the file as a .csv file, did you verify the format by reopening
in excel?

If you did, try opening that .csv file in NotePad (or some other text editor).

When I did the save as a .csv, I got what you wanted--if I looked at it in
NotePad.
 
Back
Top