CSV elements don't get split up in cells

  • Thread starter Thread starter tomf
  • Start date Start date
T

tomf

Hi,

I recently installed a German version of excel and now when I open m
CSV files they don't get seperated anymore by the commas. The whol
line is just written in one cell.
When I had the US version installed the data was split up after eac
comma and distributed into the corresponding cell.

How can I achieve the same thing in the German version
 
tom

You could try renaming the file to .txt rather than .csv When you try to
open this in Excel it will start the Text Import Wizard which will give you
much more control over the import of the data.

Andy.
 
Comma Separated Values are not always separated by commas.
The separator character used for reading and writing these files is the one
defined as the 'List separator' in the computer's Regional Settings control
panel.
 
Back
Top