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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change csv list separator in excel 2007 Dutch version 1
Exporting to CSV with embedded line breaks 1
How to change decimal separators when importing text (csv) files? 1
Excel 2007 - Importing Text Decimal Separator Issue 2
CSV file opening as a text format 1
How does Excel make it's guess as to what type of file a CSV file is? 7
CSV-file as semicolon se 2
how can I import a csv file to Excel that has over 256 columns? 2

Back
Top