Special Characters causing problems

[Vickie]

I get a report monthly from our office in Japan. They use some ＭＳ Ｐゴシック
character font that I don't recognize. When I change the formatting, all
shows up okay except there are a few characters that appear to be okay, but
are slightly different. These are random "(" and ")" and even some letters
like M or F or H. I tried to write a search and replace macro but it is not
picking up the characters properly. I would put in their CHR() properties,
but don't even know how to find out what they are. Help!! These characters
are really wreaking havoc in our DB2 database where we upload the information.

 

[John C]

Well, assuming you have the data in a cell, you could use CODE and MID to
find out the CHAR specified....
For example, say I wanted to find the code of the character where the # is
in the following phrase:
The quick re# fox jumped over the lazy brown dog.
=CODE(MID(A1,13,1))