I need to replace text from another source with my text. An example would be if the text “BLUE” is present in the cell’s text string (i.e. “JSA BLUE WALL JSIA”), then replace the entire cell text with “GAME BLUE REGION”. I have 5 text conditions I am trying to find, match, and then replace with 5 other text values. I have tried using the IF/IFS/FIND formulas but I continue to get errors with those.