Thanks,
works great!!

"Cecilkumara Fernando" <cekufdo@sltnetDOTlk wrote in message
...
JMay,
In step2 where you mark the delimiters check the "Other" check box and
Type
Alt+0160
from the number key pad. (key in 0160 while keeping the "Alt" key down)
Cecil


"JMay" wrote in message
news:zvCvc.16758$Tw.8177@lakeread06...
Often when I do a text to columns
the text has trailing spaces

like

xyz____ Viewable at xyz but len(a1) = 7

<<< the underscore characters represents trailing spaces not the
literal
underscore as shown)

Using a regular trim(A1) doesn't work.
What other ops are available?
TIA,