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

Posted on by kazamraza
Spread the love
A B C D E
1
2
3
4

 

Data
Kazam
BD123
Formula Description (Result)
 =IF(ISNUMBER(SEARCH(“m”,A2)),”OK”, “Not OK”) Checks to see if A2 contain the letter m (OK)
 =ISNUMBER(SEARCH(“BD”,A3)) Checks to see if A3 contains BD (TRUE)
 =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)
 =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)

In this example the major difference between FIND and SEARCH is that FIND is case sensitive