Forum Discussion

Brass Contributor

Nov 24, 2022

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

excel

Formulas and Functions

dscheikey

Bronze Contributor

Nov 24, 2022

Frank145

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

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

Frank145

Brass Contributor

Nov 24, 2022

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