Multiple Substitutes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi!

You have to nest them like:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"/",""),"-",""),"&","")

Biff
 
You might want to try the latest version of Longre's free morefunc.xll
add-in with functions that process regular expressions.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Cell Range Split into Multiple Cells 3
To remove numbers in a cell with out using the macro 3
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string 6
non-VBA Alternative to SUBTITUTE function 6
Substitute 7
How can I combine two formulas Left/Mid/Right + Substitute? 7
sum numbers in cell string array 6

Back
Top