CSV File, change separator sign

  • Thread starter Thread starter MR MALTWHISKY
  • Start date Start date
M

MR MALTWHISKY

I can not change separator sign creating CSV file in office2007 running on XP
PRO.
I want to have , as separator defalt is ;
I have changed in control panel nationals setting but it still does not give
me csv fil whit , as separator it keeps give me ; as separator.
Can anyone tell me how to solve this.
 
I've run into this myself, and eventually found it fastest just to use
NotePad or EditPad.

1. Export your .CSV doc
2. Open it in NotePad
3. CTRL-H to activate Search/Replace feature

Search: ;
Replace: ,

4. Save the .CSV file.
 
Back
Top