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