View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Opening .csv-files 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?
||
||
||
||
||
||
||
||
||
||
|
|