Difficulty cleaning some char(63) characters
 

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

Difficulty cleaning some char(63) characters
 

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


"Raj" wrote in message
...
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