Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
Excel Cleaning | Excel Discussion (Misc queries) | |||
Cleaning data | Excel Worksheet Functions | |||
Cleaning Up Data | Excel Discussion (Misc queries) | |||
8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) |