Does Cell Contain Text Segment

=IF(ISNUMBER(FIND("ADAM",A7)),1, 0)
=IF(ISNUMBER(FIND("ADAM",A7)),"YES", "NO")

Comments

Your email address will not be published.