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