Hi!
You have to nest them like:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"/",""),"-",""),"&","")
Biff
"Jeff" wrote in message
...
Hello,
I would like to substitute 3 different characters in my cells. I have
=SUBSTITUTE(A1,"/","")....but I would also like to substitute "-" and "&"
for
"" all in the same formula. Can it be done? Thank you.
--
Jeff
|