| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Text
I have cells that contain data in this format:
ANIMALS-PETS-DOGS-BROWN ANIMALS-PETSFARM-DOGS-BEAGLES ANIMALS-PET-CATS-TABBY What I need is the ability to extract only the last word after the last hyphen so my cells look like this: BROWN BEAGLES TABBY I am getting lost |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting text from a cell entry | Excel Discussion (Misc queries) | |||
| Extracting Surname from within a text string | Excel Worksheet Functions | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Extracting and using Text from external sources | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
