Extracting Text

M

Michael

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
 
D

daddylonglegs

With your data in A1

=REPLACE(A1,1,LOOKUP(LEN(A1)+1,FIND("-",A1,ROW(INDIRECT("1:"&LEN(A1))))),""
 
C

CLR

=MID(A1,FIND("-",A1,FIND("-",A1,FIND("-",A1,1)+1)+1)+1,99)

Vaya con Dios,
Chuck, CABGx3
 
Top