ExcelBanter - Multiple Substitutes

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple Substitutes (https://www.excelbanter.com/excel-worksheet-functions/45876-multiple-substitutes.html)

Jeff

Multiple Substitutes

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

Biff

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

Aladin Akyurek

You might want to try the latest version of Longre's free morefunc.xll
add-in with functions that process regular expressions.

Jeff wrote:
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.

All times are GMT +1. The time now is 01:44 AM.