Substitute function

  • Thread starter Thread starter jeremy.a.williams
  • Start date Start date
J

jeremy.a.williams

I have the following text in a cell "Display Ad - 1/3 page" - I want
to substitute all spaces, "/" and "-" characters with "" so my result
is "DisplayAd13page". Can I do this in one statement using
Substitute? Right now I have one cell that substitutes " " with "",
another that substitutes "/" with "" and a third that substitutes "-"
with "", so I now have 3 separate cells doing what I'd like to do in 1
statement. Is that possible?
 

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
double use of Substitution Function 2
Conundrum 7
Need Help with Substitute Formulas, etc. 5
Substitute Function Question #2 5
Split Cell Range into Multiple Cells 1
Substitute to Retun a number 2
'Substitute' function with wildcards 1

Back
Top