Making Semi-Colon Delimited Fields
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 |
Making Semi-Colon Delimited Fields
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 |
All times are GMT +1. The time now is 12:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com