Difficulty cleaning some char(63) characters

[Raj]

Hi,

I am having two strings with different first characters. One looks
looks like a pair of "L"s and the other a solid vertical block. Both
these characters are at the beginning of the string. When the code
function is run both return the value 63. However, when I run
substitute(a1,char(63),"") the character is not subsituted with "".
Char(63) incidentally looks like a question mark..

How do I clean these characters which return char(63) but do not
respond to the substitute function on them?

Thanks in advance for all the help.

Regards,
Raj

 

[Bernie Deitrick]

Raj,

They might be extended ascii characters, if you are copying from, say, a website. Could you just
use

=MID(A1,2,len(A1))

HTH,
Bernie
MS Excel MVP