Find text within a comma separated cell

Hi   I am trying to determine if a text value is within a cell and if so record result as a “Yes” within another cell.   For example I have text in my tag column D that is comma separated. As an ...