Data,Text to Columns Clean up
2 q's:
I guess a check the "other box" in addition to (along with) the space
option box (already or previously checked).
Obviously something is happening "under the hood" as you do the Alt-0160 <<
though nothing visually is happening. right?
Thanks again.
JMay
"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,
|