# Find text within a comma separated cell

Occasional Contributor

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

# Re: Find text within a comma separated cell

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

You can try this formula.

# Re: Find text within a comma separated cell

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

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

# Re: Find text within a comma separated cell

That worked perfectly; Thank you so much.

Best regards

# Re: Find text within a comma separated cell

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