Change of field separator

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I open CSV files in Excel all data is put in one column. Can anyone tell
me, where I change my set up, so I get another field separator? Please be
specific, because my Excel is a Danish version, and sometimes I have a hard
time following the English instructions. Thanks!

Jane
 
Hi
you specify this in the Windows regional settings. Another idea:
- rename your *.csv file to a *.txt file
- now open it with excel. The Import wizard should appear and should allow
you to specify a different delimiter
 
You must log in or register to reply here.

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

How to set the list separator 4
Open CSV In One Column or Multiple Columns? 2
Formula to add spaces in csv 4
change csv list separator in excel 2007 Dutch version 1
Change of field separator in csv files (comma separated) 3
CSV formatted files open odly in Excel 2000 3
semicolon separated CSV file 4
Open a *.csv file? 2

Back
Top