ISNUMBER – Kazam Raza

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

Posted on December 27, 2023January 20, 2024 by kazamraza

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...

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

Posted on December 25, 2023January 20, 2024 by kazamraza

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)