WE GOT A HIT!!!! I learned yet another thing... yes using number pad
allows data entry into FIND of ASCII Char() .

with number pad, entering 160 produces character that looks like an "a"
which my DOS book says is char(160) . Seems logical.

At first, when I entered 0160 into replace, I thought it didn't work.
then I noted that the was a blank space in the find field of the find
and replace dialog box. I then hit "replace all" and immediate all the
mysterious spaces were gone.

THANKS

Peo Sjoblom wrote:
Most likely you have invisible html characters, try this
do editreplace, in the find what box hold down alt key and type 0160 on the
numpad, release the alt button, leave replace with empty
click OK

If you do this often you might want to use a macro

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


same web site has info on how to install macros