CSV files

  • Thread starter Thread starter gabysosa
  • Start date Start date
G

gabysosa

I try to open .CSV files from excel but they open in a single column.

Help
Tks,
Gaby
 
This can happen if the windows list separator (under control panel|regional
settings) doesn't match the separator used in the .CSV file.

For instance, with my USA settings, my windows list separator is a comma (,).
If I import a file that uses a semicolon (;) as its separator, then all the data
goes into a single column.

I can either change my windows list separator (temporarily) and then reimport
the .CSV file. Or I can select column A and do data|Text to columns and specify
the matching separator there.
 
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 Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Lotus notes attachment opening return receipt 0
References to cells in another workbook 3
dump a multiple sheet excel file to a single text file 3
Looking for IF with VLOOKUP statement with two conditions. 6
.csv Format Questions 1
Export Pivot table 1
Excel parsing unicode csv file 2

Back
Top