Your Exercise

Please download here.

To check if a cell contains specific text, you can use the ISNUMBER and the SEARCH function in Excel. There's no CONTAINS function in Excel.

1. To find the position of a substring in a text string, use the SEARCH function.

2. Add the ISNUMBER function. The ISNUMBER function returns TRUE if a cell contains a number, and FALSE if not.

3. You can also check if a cell contains specific text, without displaying the substring. Make sure to enclose the substring in double quotation marks.

5. Add the IF function. The formula below (case-insensitive) returns "Found" if a cell contains specific text, and "Not Found" if not.

6. You can also use the IF and the COUNTIF function in Excel to check if a cell contains specific text. However, the COUNTIF function is always case-insensitive.

Explanation: the formula in cell C2 reduces to =IF(COUNTIF(A2,"*duck*"),"Found","Not Found"). An asterisk (*) matches a series of zero or more characters. Visit our page about the COUNTIF function to learn all you need to know about this powerful function.