Hidden character in String and can't remove

[JumboCactuar]

Hi,
I have text in a cell A1: Tomasevska
If i do

MsgBox Len(Range("A1"))

It shows as 11 characters when it should be 10

and if i debug.print it shows:

Does anyone know why that is happening and how to resolve?


Thanks in advance

 

[Joe4]

Probably a special character.
I am willing to bet that you either got this data from the internet or from another program?
They often have extra special characters, like non-breaking spaces in them.

Place this formula in any blank cell on your sheet to see what it returns.
It will tell you the ASCII code of the last character:

=CODE(RIGHT(F18,1))

 

[RoryA]

Try:

msgbox ascw(right$(Range("A1").value, 1))

to see the character code.