I am unable to identify and remove an extended character from cells in a worksheet.
The data comes from an download (Oracle I think).
The unwanted characters are invisible characters (assumed to be an in the extended character set).
These characters are in the first and last character positions of each cell.
I was able to identify them with the =LEN() function which gave the character string length of 2 characters more than the number of visible characters.
When it check it from VB with the 'ASC' function it incorrectly indicates that it is ASCII character 63 (which is the Question Mark and is a visible character).
But if I test that first character against a "?", it resolves to FALSE (further indicating the VB incorrectly identifies this character).
The main reason for trying to remove these characters is that the VLOOKUP() function fails to match these cells against another worksheet with these data strings that originated from another source and truly do not have these extended characters.
My goal is to be able to identify and remove these unwanted characters with a VB macro, so a VLOOKUP() can be properly performed.
(A workbook is attached with a sample of the problem cells)