![]() You can also use IF and COUNTIF in Excel to check if a cell contains specific text. The formula below (case-insensitive) returns "Found" if a cell contains specific text, and "Not Found" if not.Ħ. Cell A3 does not contain the word "donkey" but contains the word "Donkey".ĥ. To perform a case-sensitive search, replace the SEARCH function with the FIND function.Įxplanation: the formula in cell C3 returns FALSE now. Make sure to enclose the substring in double quotation marks.Ĥ. ![]() You can also check if a cell contains specific text, without displaying the substring. ![]() The ISNUMBER function returns TRUE if a cell contains a number, and FALSE if not.Įxplanation: cell A2 contains the word "duck", cell A3 contains the word "donkey", cell A4 does not contain the word "horse" and cell A5 contains the word "goat".ģ. Explanation: "duck" found at position 10, "donkey" found at position 1, cell A4 does not contain the word "horse" and "goat" found at position 12.Ģ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |