Substitute function
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," ",""),"-",""),"/","")
--
Gary''s Student
gsnu200703
" wrote:
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?
|