chr(32) vs chr(160) ??

[39N95W]

What's the difference between these two? I looked it up and 32 is a space,
as most of you know, but 160 is called a non-breaking space? Is there a way
to get the Trim function to work on the 160's?

TIA.

-gk-

 

[JE McGimpsey]

a non-breaking space does not act as a word separator for the purpose of
soft-breaking lines.

To remove, see David McRitchie's TrimAll macro:

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