| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Remove hyphens in text
Satisfying all the above examples, which may be reduced to the rule:
'remove all hyphens other that that preceding an s', you can use: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(D9,"'s","~"),"'" ,""),"~","'s") replace d9 with the cell your evaluating, if necessary, replace ~ with any character that wont be appearing in the source cells being evaluated. Regards, Sam |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove all spaces in a text string | Excel Discussion (Misc queries) | |||
| remove text that pops up with combo box | Excel Worksheet Functions | |||
| Remove cells with text not relevant | Excel Worksheet Functions | |||
| how do I remove empty spaces trailing a text string? | Excel Worksheet Functions | |||
| How do I remove all text to the left of the @ in an email address | Excel Worksheet Functions | |||
Threaded Mode
