Exporting CSV data and using semi colon instead of comma

  • Thread starter Thread starter Michel Girard
  • Start date Start date
M

Michel Girard

Does anybody know of a way to export data in excel as a
CSV file and use a semi colon(;) as the separator instead
of a comma (,)?

I can do it through a macro, but don't want to use that
if I don't have to.

Thanks
Michel
 
Try changing your Windows Regional settings.

Windows Start Button|settings|Control Panel|Regional Settings Applet
Number Tab|List separator

Don't forget to change it back when you're done. It's a windows wide setting.

And if you do decide to go the macro route:

Earl Kiosterud wrote a text export program. It's available at:
It's available at Tushar Mehta's site:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

Earl has a bunch of options that you can specify.

And you may want to look at Chip Pearson's code:
http://www.cpearson.com/excel/imptext.htm
 
Back
Top