chr(32) vs chr(160) ??
 

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-

chr(32) vs chr(160) ??
 

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


In article ,
"39N95W" wrote:

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?