A cell will contain the words "GREEN", "YELLOW", or "RED". FWIW, the words will be surrounded by asterisks (e.g, "***GREEN***").
I am trying to craft an elegant formula that will parse the cell and return "Green", "Yellow", or "Red".
This is the formula I have so far, but it errors out if the original cell does not contain the first color ("GREEN"):
I could add "iferror" I guess, but there may be a better way?
Is there a more elegant solution? Thanks.