Forum Discussion

Frank145's avatar
Frank145
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
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Nov 24, 2022

Frank145 

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

You can try this formula.

 

  • Frank145's avatar
    Frank145
    Brass Contributor
    Nov 24, 2022

    OliverScheurich 

     

    That worked perfectly; Thank you so much.

     

    Best regards

     

Resources