Hi Ray,
When posting please include the question in the text body.
Not everything that appears to be a space is a space, frequently
when copying from HTML you will copy a non-breaking space
character ( ) or char(160) also known as a required blank (RBL)
in some places.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
---
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
"rayhollidge" wrote in message ...