How to detect symbol/special character code
If you put the particular character in a cell then use a formula like
=CODE(A1)
you will get the number for the character set for your computer, so if you
have a space it will return 32
=CHAR(32)
will return a space
so if you want to replace CHAR(32) do ctrl + h, then in the find what box
hold down the alt key while typing 032 on the numpad and the leave replace
with blank the space(s) should be gone
--
Regards,
Peo Sjoblom
"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"?
|