Find text within a comma separated cell

Occasional Contributor

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 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

@Frank145 

=IF(ISNUMBER(SEARCH("Databases",D2)),"Yes","")

You can try this formula.

find text.JPG 

@Frank145 

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

=ISNUMBER(FIND("Databases",A1))

 

@Quadruple_Pawn 

 

That worked perfectly; Thank you so much.

 

Best regards

 

Hi

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