The replace text argument could be blank as below

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C4,"#",),"?",)," ~",)

--
Jacob (MVP - Excel)


"Fred Smith" wrote:

Nest not a function. It's just a description of putting one function within
another. So what you need is:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C4,"#",""),"?"," "),"~","")

Regards,
Fred

"Raja Mahendiran S" <Raja Mahendiran wrote in
message ...
Hi All,

I need to remove multiple string (special characters) in an excel field.

Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this
without using Nest Function.

Please help!!!

Thank You

.