View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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"?