OK, thanks, I'm glad and relieved to learn that. The TRIM
documentation agrees with what you say, and I expected it to behave
that way, too, and was surprised when it didn't.

The non-breaking space must have been what was trailing the cells in
one of my columns.

Thanks for your help, a big help.


On Thu, 26 Aug 2010 09:44:39 -0700, "Jim Cone"
wrote:

"TRIM() retains all single spaces in a string, even a single trailing space."

Well, not exactly... leading and trailing spaces are removed by Trim().
There is a non-breaking space character (160) that is impervious to the Trim and the Clean functions.
It can be removed using the Substitute function... =SUBSTITUTE(E10,CHAR(160),"")