How to save a CSV?

  • Thread starter Thread starter serdar
  • Start date Start date
S

serdar

I want to save a CSV file but not seperated with comma not semicolon, plus
quoted string values. How to change the settings while saving a CSV file?
 
You can change the separator by changing the windows list separator under
control panel regional settings (number tab).

But I'm not aware of anything that will change how quotes are applied. If excel
thinks it needs them, you get them. If excel doesn't think it needs them, you
don't get them.

But you could write your own macro to extract the data in whatever form you
want:

Some sample code to get you started:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.ht
 
Back
Top