Thanks Tom. I got this to work. I guess there is no "Automatic" way to get
this to work (ie hands off)

"Tom Ogilvy" wrote:

http://www.cpearson.com/excel/imptext.htm import/export text files
Chip Pearson's site.

--
Regards,
Tom Ogilvy


"markshunter" wrote:

Anyone have any way to import a csv file that is separated by semi-colons
into a spreadsheet?
I am hoping i can take the file and parse it out by the semicolons and use
the top line as the heading line (titles).