After you open this file all of your data should be in column A, select
this column and Data, Text to Columns, Delimited, by semicolon should
give you the result you seek.
copy and paste your data into excel
select the column containing the data with ; as the separator
Data | Text to columns | Delimited | Next | Select Semicolon | Next | Finish
Rename the .csv file to .txt. Then use file|open to open that .txt file.
You'll see the data import wizard and you'll be able to specify that the
semicolon is the delimiter.
Another option would be to change your windows regional settings list separator
to a semicolon. (I'd only do this temporarily since it's a windows setting).
In winXP,
Windows start button|control panel|regional and language options
Regional Options tab|click the customize button|Numbers tab
list separator.
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.