Try the TrimAll macro to remove spaces and
non-breaking-spaces.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message oups.com...
I have read every explanation I could find on the Internet of how to
convert imported numbers that don't act like numbers. I have done the
PasteSpecial trick until my fingers are sore, without success. Is there
a way to find out the properties of a cell? Do some cells resist the
normal tricks?
thanks
jr