David wrote on Wed, 26 Sep 2007 18:15:09 +0100:

DB =CODE(MID(A1,n,1)) where you are trying to find the code
DB for the nth character in cell A1.
DB --
DB David Biddulph

DB "Jeff Ingman" wrote
DB in message
...
?? I often find symbols in MS documents I'd like to remove or
?? replace with something else.
??
?? Is there a way to detect the underlying code of a symbol
?? or special character to use for "Search and Replace"?

My earlier answer was to the question of *replacing* an unknown
character. If you want to know what actually was the unknown, I
don't know an answer offhand. CODE(MID(A1,1,1), say, in Excel
2002 will not always work. To take a simple example, I inserted
the Russian character "yah" (R written backwards), 042F in Word,
copied it and pasted it into Excel. CODE(MID(A1,1,1)) gave 63.
I'm not sure what that means since it's not even
MOD(HEX2DEC("042F"),256) as I might have suspected.



James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not