View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jeremy.a.williams@gmail.com is offline
external usenet poster
 
Posts: 3
Default 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?