| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove dash(s)
Maybe someone here could provide guidance:
Have a column containing data which may have 1-3 dashes locates within each cell value. Such as: 125-457A 158-857-1116 124184A-1 125-8745-22D9 458-2145-002-7 Would like to remove all the dashes "unless" the last dash to the right is followed by a just a single digit. The results would be as follows: 125457A 1588571116 124184A-1 125874522D9 4582145002-7 On the example data, it kept 2 of the dashes in the cell values, because the were only one digit away from the extreme right, but removed all others. TIA for any thoughts. Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i remove the several hyperlink option after entering the . | Excel Discussion (Misc queries) | |||
| How can i remove the several hyperlink option after entering the . | Excel Discussion (Misc queries) | |||
| remove characters from a text under a condition | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| how do i remove hyphens from between numbers | Excel Worksheet Functions | |||
Threaded Mode
