I'd guess your windows settings for the list separator is different from what
the program uses.
You could change your windows setting (from a semicolon to comma???), but that
affects all of windows. I would guess that you'd want to change it back after
you import the data. (It's under windows control panel|regional settings).
But since you have the data in column A, you could select column A and do
Data|Text to columns and specify the separator character.
After that's done, you can save the way you want.
Bigtherms wrote:
Ok thanks –Slight confession needed since my first posting! Sorry I was
confused.
I’m actually using Excel 97 – I have a .csv file generated from a
Product Management System for CAD that when opened in 97 has all info
per row in the first cell. (what I now understand is probably Tab or
Space delimited)
What I need is this to be Comma Delimited but it’s not obvious in 97
how to convert or configure to be Comma Delimited upon opening.
I believe in 2000 there is a option under Data/ Get External Data.
So any ideas for this one? :)
Regards,
Ryan.
--
Bigtherms
------------------------------------------------------------------------
Bigtherms's Profile: http://www.excelforum.com/member.php...o&userid=25904
View this thread: http://www.excelforum.com/showthread...hreadid=392834
--
Dave Peterson