| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting Text
With your data in A1 =REPLACE(A1,1,LOOKUP(LEN(A1)+1,FIND("-",A1,ROW(INDIRECT("1:"&LEN(A1))))),"") -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=523228 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting Text
Thanks that one did the trick for me.
"daddylonglegs" wrote: With your data in A1 =REPLACE(A1,1,LOOKUP(LEN(A1)+1,FIND("-",A1,ROW(INDIRECT("1:"&LEN(A1))))),"") -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=523228 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting Text
=MID(A1,FIND("-",A1,FIND("-",A1,FIND("-",A1,1)+1)+1)+1,99)
Vaya con Dios, Chuck, CABGx3 "Michael" wrote: 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 |
| Reply |
| 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) | |||
Hybrid Mode
