That formula works for some of it...but it isn't always in that format. I need a formula that will search a list of words for a match in the desired cell.

If there is a match, the result will be that word.