Forum Discussion

Frank145's avatar
Frank145
Copper 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 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?

excel
Formulas and Functions

4 Replies

Sort By
  • dscheikey's avatar
    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's avatar
      Frank145
      Copper 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

Resources