Data,Text to Columns Clean up

J

JMay

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,
 
C

Cecilkumara Fernando

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
 
J

JMay

Thanks,
works great!!

Cecilkumara Fernando said:
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
Click to expand...
 
J

JMay

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
 
C

Cecilkumara Fernando

JMay,
It is a character called "No Brake Space" which is in 160 of the extended
keyboard.
you can get it in to a cell by using the formula =char(160) or doing the
Alt-0160.
at the worksheet level you can do find and replace, Find What Alt-0160
replace with nothing.
lot of those come in when you do copy/paste from web pages.
regards,
Cecil
 
Top