Detection of chinese space character?

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.

Moo,
The offending code is a 160 (decimal A0 hex) as opposed to the code for a space with is a 32 (decimal 20 hex).

So can I do a special find and replace using the Find/Replace dialog and put either to decimal or Hex values in? Maybe something like %20 or something.
These space characters are all over the data I receive, every space in fact.
Thanks

I decided to write a macro for my plugins. It is below. I do not know if the hex Ao space copied in this paste, but it did when I recorded this snippet of code.
Before you use this please virify using the function Moo outlined above.
I will use this on the entire worksheet when I get data in.
Thanks and marking this Solved.

Please Login or Register  to view this content.