| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing text between hyphens and removing the hyphens
I am a bit new with regards to excel but If have a column of data that has
values in this format (note the placement of the hyphens) 9999- RR - AAAAAAAAAA The length of 9's are constant at 4 The length of A's can change between cells I would like to remove the R's and hypens to have this: 9999 AAAAAAAAAAA Any suggestions? Thanks for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Hyphens in phone list??? | Excel Discussion (Misc queries) | |||
| Macro For Removing Hyphens | Excel Discussion (Misc queries) | |||
| Automatically removing hyphens from ID# or SSN. | Excel Discussion (Misc queries) | |||
| Remove hyphens in text | Excel Worksheet Functions | |||
| Does XL2K have "hard hyphens" (non-break hyphens)? | Excel Discussion (Misc queries) | |||
Threaded Mode
