| 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