I have a word macro the regularises units as typed in by the user. This macro is applied once I receive the document for further editing.

e.g



123°C 123 °C 123C etc become 123 °C after I run the macro.

The macro is basically a set of search and replace instructions using the wildcard function.

However I have a document that was edited by Japanese colleagues where the ° symbol is not found by my macro. If I print the AscW value of the character used by my Japanese colleagues it is reported as 40 rather than 176. The character normally assigned to the value 40 is the left parenthesis character (.

A similar problem also occurs where Tab characters appear as a square symbol. In this case the square symbol has an Ascw value of 12288.

I've attached a small document which includes text with these strange characters.

I'd really appreciate some help as trying to resolve this issue is driving me bonkers.

Attached Files

Japanese editing problem.doc (39.5 KB, 25 views)