Columns("E:E").Replace What:="~?", _
Replacement:="", _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False, _
SearchFormat:=False, _
ReplaceFormat:=False


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Raju" wrote in message
...
I have some numerical data in a excel worksheet which is downloaded from
another application. By mistake in some of the fields some non numberical
characters(Ex: "?") are entered. I want to eliminate "?" character using
VBA.
Please help.