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.