For cleaning up data, see the TrimAll macro, which you can
customize, of course.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
based on the Topic you would also be interested in
http://www.mvps.org/dmcritchie/excel/proper.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Steve" wrote in message ...
Roger,
Thank you for your help, i have had a look at David McRithcie's site but
couldnt find anything, to be honest i dont really know what im looking for.
Any further help would be most helpful.
Thanks again
Steve