Posted to microsoft.public.excel.worksheet.functions
|
|
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string
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
|