How to detect symbol/special character code
You're referring to *MS* documents in your post.
Since this is an XL group, this is what I do to find the code in XL sheets:
=Code(A1)
Will return the code for the *first* character in the cell A1, whether
visible or invisible.
If you know, or suspect a character (invisible) is elsewhere in the cell,
you can use something like this:
=CODE(MID(A1,2,1))
Where you're referencing the *second* character, or
=CODE(MID(A1,3,1))
Where you're referencing the *third* character,
And so on ... !
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jeff Ingman" wrote 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"?
|