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,