If statement contains text (Excel 2010 Formula)

=IF(SEARCH(“Text”,A2)),”Yes”, “No”)

This checks if cell A2 has Text anywhere inside of it.

 

Leave a Reply

Your email address will not be published. Required fields are marked *