I write semicolon separated .csv-files from another application and open
them in Excel. It works excellent on my computer. I just open the file and
data is organised in columns as I would expect.
If I do the same thing on certain other computers with the same Excel
version (2003), all data of each row is imported to the first Excel colums
as one string. I have looked a lot for a setting in Excel that contol this
import, but not found any. Have I missed something?
It is of course possible to import data from the csv-file by data/import
external data, but that is a more complicated way, and the people who shall
work with this is not so familiar with Excel.
To sum it up: How is data import controlled when a text file is opened in
Excel?

Hi Bengt

Its probable that the Regional settings are different on the computers.
Yours must be set to use ; as the separator, hence Excel knows exactly how
to parse the data.
Other machines may be set with ' as the separator, so Excel doesn't know how
to parse the data with ;

If you cannot make the Regional settings the same on all computers, when
Excel imports it all into column a, select column ADataText to
ColumnsDelimitedOther ; Finish
--
Regards
Roger Govier

"Bengt" wrote in message
...
I write semicolon separated .csv-files from another application and open
them in Excel. It works excellent on my computer. I just open the file and
data is organised in columns as I would expect.
If I do the same thing on certain other computers with the same Excel
version (2003), all data of each row is imported to the first Excel colums
as one string. I have looked a lot for a setting in Excel that contol this
import, but not found any. Have I missed something?
It is of course possible to import data from the csv-file by data/import
external data, but that is a more complicated way, and the people who
shall work with this is not so familiar with Excel.
To sum it up: How is data import controlled when a text file is opened in
Excel?

Of course, there is semicolon listed as a separator - use that, no need to
use Other.

--
Regards
Roger Govier

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Bengt

Its probable that the Regional settings are different on the computers.
Yours must be set to use ; as the separator, hence Excel knows exactly how
to parse the data.
Other machines may be set with ' as the separator, so Excel doesn't know
how to parse the data with ;

If you cannot make the Regional settings the same on all computers, when
Excel imports it all into column a, select column ADataText to
ColumnsDelimitedOther ; Finish
--
Regards
Roger Govier

"Bengt" wrote in message
...
I write semicolon separated .csv-files from another application and open
them in Excel. It works excellent on my computer. I just open the file
and data is organised in columns as I would expect.
If I do the same thing on certain other computers with the same Excel
version (2003), all data of each row is imported to the first Excel
colums as one string. I have looked a lot for a setting in Excel that
contol this import, but not found any. Have I missed something?
It is of course possible to import data from the csv-file by data/import
external data, but that is a more complicated way, and the people who
shall work with this is not so familiar with Excel.
To sum it up: How is data import controlled when a text file is opened in
Excel?

Perhaps you have semicolon set as list separator in Windows Regional
settings, while some other Character is set on the other Computers. Check it!

Regards,
Stefi


€žBengt€� ezt Ã*rta:

I write semicolon separated .csv-files from another application and open
them in Excel. It works excellent on my computer. I just open the file and
data is organised in columns as I would expect.
If I do the same thing on certain other computers with the same Excel
version (2003), all data of each row is imported to the first Excel colums
as one string. I have looked a lot for a setting in Excel that contol this
import, but not found any. Have I missed something?
It is of course possible to import data from the csv-file by data/import
external data, but that is a more complicated way, and the people who shall
work with this is not so familiar with Excel.
To sum it up: How is data import controlled when a text file is opened in
Excel?

I'm not sure, but it might be that on your computer the list separator is set to a semicolon, while on the other it is a space (or
even something else)
look in Control Panel, Date, Time. Language and Regional Options

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bengt" wrote in message ...
|I write semicolon separated .csv-files from another application and open
| them in Excel. It works excellent on my computer. I just open the file and
| data is organised in columns as I would expect.
| If I do the same thing on certain other computers with the same Excel
| version (2003), all data of each row is imported to the first Excel colums
| as one string. I have looked a lot for a setting in Excel that contol this
| import, but not found any. Have I missed something?
| It is of course possible to import data from the csv-file by data/import
| external data, but that is a more complicated way, and the people who shall
| work with this is not so familiar with Excel.
| To sum it up: How is data import controlled when a text file is opened in
| Excel?
|
|
|
|
|
|
|
|
|
|

<while on the other it is a space

I meant a comma.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message ...
| I'm not sure, but it might be that on your computer the list separator is set to a semicolon, while on the other it is a space
(or
| even something else)
| look in Control Panel, Date, Time. Language and Regional Options
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Bengt" wrote in message ...
||I write semicolon separated .csv-files from another application and open
|| them in Excel. It works excellent on my computer. I just open the file and
|| data is organised in columns as I would expect.
|| If I do the same thing on certain other computers with the same Excel
|| version (2003), all data of each row is imported to the first Excel colums
|| as one string. I have looked a lot for a setting in Excel that contol this
|| import, but not found any. Have I missed something?
|| It is of course possible to import data from the csv-file by data/import
|| external data, but that is a more complicated way, and the people who shall
|| work with this is not so familiar with Excel.
|| To sum it up: How is data import controlled when a text file is opened in
|| Excel?
||
||
||
||
||
||
||
||
||
||
|
|

What list separator is defined in your Windows Regional Settings? [It's a
Windows setting, not Excel.]

Try changing it from a comma to a semi-colon, then try to open your CSV.
--
David Biddulph

"Bengt" wrote in message
...
I write semicolon separated .csv-files from another application and open
them in Excel. It works excellent on my computer. I just open the file and
data is organised in columns as I would expect.
If I do the same thing on certain other computers with the same Excel
version (2003), all data of each row is imported to the first Excel colums
as one string. I have looked a lot for a setting in Excel that contol this
import, but not found any. Have I missed something?
It is of course possible to import data from the csv-file by data/import
external data, but that is a more complicated way, and the people who
shall work with this is not so familiar with Excel.
To sum it up: How is data import controlled when a text file is opened in
Excel?