Hello,

Is it possible to open a csv-file with a number of columns that are
separated be a certain separator in Excel, so that Excel puts the text in
the right columns automatically by looking at the separator. I want Excel to
do this without using the wizard 'Text to Columns'. This works fine for me
when I use the semicolon as separator. I presume this is the default
separator. But how can I change this separator to for example a comma, so
that Excel can also open my comma-separated files in a correct way
automatically?

I've already tried to change the 'List Separator'-setting in the 'Regional
Settings' to a comma, but this doesn't work. Does anyone know the answer
please?

Thx,

Lieven

Since you posting in Programming, for maximum control, do it with a macro.

See Chip Pearson's page on this topic:

http://www.cpearson.com/excel/imptext.htm#Import
Import Text Files

--
Regards,
Tom Ogilvy

"Lieven Mettepenningen" wrote in message
...
Hello,

Is it possible to open a csv-file with a number of columns that are
separated be a certain separator in Excel, so that Excel puts the text in
the right columns automatically by looking at the separator. I want Excel
to
do this without using the wizard 'Text to Columns'. This works fine for me
when I use the semicolon as separator. I presume this is the default
separator. But how can I change this separator to for example a comma, so
that Excel can also open my comma-separated files in a correct way
automatically?

I've already tried to change the 'List Separator'-setting in the 'Regional
Settings' to a comma, but this doesn't work. Does anyone know the answer
please?

Thx,

Lieven