13 is a carriage return.
--
David Biddulph

"Jeff Ingman" wrote in message
...
Thank you for your post Peo.

I tried your suggestion and got "13" as the code for the symbol I wanted
to
remove. I opened the search/replace box and typed Alt 013 and hit Replace
All. I got an error message saying "Microsoft Office Excel could not find
any
data to replace...."

"Peo Sjoblom" wrote:

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