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

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