Trim and Formatting marks 1

[sylve]

Simple but long question...

I am trying to treat a string but but it wont take away what LOOKS like trailing spaces at the right.

This:
Trim(CleanString(myRange.Text))

Returns a string like this (without brackets):
"Axle Box "

Right(Trim(CleanString(myRange.Text),3) returns "ox "

In my watches window, i noticed a little square sign beside the text, instead of the spaces. What is this formatting mark and what do i do?

Lil

 

[bluedragon2]

This could be a return mark or some other character not recognized as a space. An easy way to get rid of them is to copy one and in the find/replace paste it in the find and leave the replace blank.



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[sylve]

Well i couldn`t apply your solution BUT it gave me the idea to do the search replace thing with a "record macro" running.

With Selection.Find
.Text = vbTab

So i got my answer, it`s a vbTab, thanks for the idea!