Also

=CLEAN(A1)

removes those characters, so you can use that formula then paste special as
values over the old data

--


Regards,


Peo Sjoblom


"Peo Sjoblom" wrote in message
...
Interesting, it works for any other characters like char(10) (carriage
return)
Anyway if you do this on a regular basis you'd be better of using code,

Sub RemoveChr13()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Selection.SpecialCells(xlConstants).Replace What:=Chr(13), _
Replacement:="", _
LookAt:=xlPart, SearchOrder:=xlByColumns, MatchCase:=True
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub


Instructions on how to install macros

http://www.mvps.org/dmcritchie/excel/install.htm



--


Regards,


Peo Sjoblom





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