Try this code written by Chip Pearson. It lets you specify the delimiter:

http://www.cpearson.com/excel/imptext.htm import/export text files

--
Regards,
Tom Ogilvy

"Dave DJ" wrote in message
...
Hello All, (Excel 2000)

I have a Excel spreadsheet that has a number of columns.
(all values in each column) What I need to do for my
General Ledger package is to make the columns (fields)
semi-colon delimited to be imported. I have tried various
things but can't get the semi-colon to show so it can be
the delimiter for import. Can somebody help me out?

Thanks in advance

Dave