{"id":3831,"date":"2019-01-02T17:12:30","date_gmt":"2019-01-02T17:12:30","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3831"},"modified":"2024-03-29T13:51:58","modified_gmt":"2024-03-29T13:51:58","slug":"if-cells-contain-specific-text","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/if-cells-contain-specific-text\/","title":{"rendered":"Excel if Cells Contain Specific Text"},"content":{"rendered":"\n
To check whether a cell contains specific text, you can use the SEARCH function<\/a>. This function will return the position of the first match and the #VALUE!<\/strong> error otherwise.<\/p>\n\n\n\n Because we don\u2019t want to have errors in our formula, we are going to use the SEARCH<\/strong> function with the ISNUMBER function<\/a>. ISNUMBER<\/strong> returns TRUE<\/strong> if there is a number and FALSE<\/strong> if there is anything else.<\/p>\n\n\n\n The following formula will return TRUE<\/strong> if there is specific text inside a cell, and FALSE<\/strong> otherwise. This version is case-insensitive.<\/p>\n\n\n\n If you want to use the case-sensitive version, you can use the following formula.<\/p>\n\n\n\n=ISNUMBER(SEARCH(substring,string))<\/pre>\n\n\n\n
=ISNUMBER(FIND(substring,string))<\/pre>\n\n\n\n
If cells contain the specific text then count<\/h2>\n\n\n\n