Check if part of a cell matches specific text (1)

Spread the love
Data
Kazam
BD123
Formula Description (Result)
 =IF(ISNUMBER(FIND(“m”,A2)),”OK”, “Not OK”) Checks to see if A2 contain the letter m (OK)
 =ISNUMBER(FIND(“BD”,A3)) Checks to see if A3 contains BD (TRUE)