Find text within a comma separated cell

Occasional Contributor



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 example: (Act, Databases) are within a cell. I wanted a formula to search the column D for “Databases” and add a Yes within another cell. 

can you help me?

4 Replies



You can try this formula.

find text.JPG 


You can use the following formula if the entry you want to search is in cell A1.





That worked perfectly; Thank you so much.


Best regards



Thanks for responding.

That did not work as expected. It gave me only a "False" message

What did was the recommendations from Quadruple_Pawn.

Best regards