Visit our page about the COUNTIF function to learn all you need to know about this powerful function. An asterisk (*) matches a series of zero or more characters. However, the COUNTIF function is always case-insensitive.Įxplanation: the formula in cell C2 reduces to =IF(COUNTIF(A2,'*duck*'),'Found','Not Found').

You can also use IF and COUNTIF in Excel to check if a cell contains specific text. The last two columns are names by the International Electrotechnical Commission. Each column lists one or more manufacturer and each row lists the equivalent battery models for each manufacturer. The formula below (case-insensitive) returns 'Found' if a cell contains specific text, and 'Not Found' if not.Ħ. Battery Cross Reference for Button Cell Batteries: The following table is a cross reference of button cell batteries made by different manufacturers. 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.Ģ.

Cross reference for timex m cell