Excel Formulas
Excel Formulas
Section titled “Excel Formulas”Is substr in String
Section titled “Is substr in String”=IF(ISNUMBER(SEARCH("ccc", A1)), "TRUE", "FALSE")Concatenate strings
Section titled “Concatenate strings”=CONCAT(A1, " ", B1)=IF(ISNUMBER(SEARCH("ccc", A1)), "TRUE", "FALSE")=CONCAT(A1, " ", B1)