excel spreadsheet has little bits of embedded code in it ? help needed

[Danny Bowers]

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

 

[pfsardella]

David McRitchie's TrimAll mscro can probably handle this for you.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

HTH
Paul

 

[pfsardella]

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