excel spreadsheet has little bits of embedded code in it ? help needed
Hello there I have a personal contacts database which I want to import into Outlook. As an interim step I have exported it into excel. The data has little bits of embedded code in it. I need to remove these. I can do it manually line by line but this will take hours. Can anyone help me with a bit of programming to clean up the database See an example from the excel spreadsheet at http://www.danny.dircon.co.uk/problemcode.htm Any help gratefully welcomed. Regards Danny |
excel spreadsheet has little bits of embedded code in it ? help needed
David McRitchie's TrimAll mscro can probably handle this for you.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- I have a personal contacts database which I want to import into Outlook. As an interim step I have exported it into excel. The data has little bits of embedded code in it. I need to remove these. |
excel spreadsheet has little bits of embedded code in it ? help needed
Danny,
I tried to respond to your EMail but it bounced back as undeliverable. Send me a copy of the Excel workbook (or a sample if the workbook is huge). Paul |
All times are GMT +1. The time now is 08:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com