View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How to detect symbol/special character code

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

"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"?