All,
I received a file from a vendor. In that file was a cell that had a value like "Company Name" with what appeard to be a space between the two words.
I tried to compare it to the value I had on another sheet. They appeared identical to the eye. The =len() function said they were the same length.
But when I put to two values in adjacent cells, A1 and A2, the expression =A1=A2 returned FALSE.
If I removed the two spaces from each, the expression returned TRUE.
If I delete the space and replace it with a space from my English keyboard, it evaluates as TRUE.

I suspect that a Chinese keyboard was used to enter the space, but do no know.

Any ideas on how to detect this in the future?
Any ideas how can I find out what the ASCII code in the offending space character is?

Thanks.