Substitute function
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?
|