Does Cell Contain Text Segment =IF(ISNUMBER(FIND("ADAM",A7)),1, 0) =IF(ISNUMBER(FIND("ADAM",A7)),"YES", "NO")