| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Function to next Column | Excel Worksheet Functions | |||
| VBA | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
