Excel Formulas to Test the Cells that Contains Specific Text!!

One of the most common tasks in Excel is checking whether a cell contains a value of interest. What kind of value can that be? Just any text or number, specific text, or any value at all (not empty cell). Today, I introduce some cute formulas to check the cell that contains specific text in Excel. Let’s jump into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

  • Use the below formula to test the cell that contains specific text.

=ISNUMBER(SEARCH(substring,text))

Syntax Explanations:

  • ISNUMBER – This function helps to check Multiple Conditions and returns TRUE if all the conditions are evaluated as true, otherwise returns FALSE. Read more on the ISNUMBER Function.
  • *SEARCH * – In Excel, the SEARCH function locates the character between two text strings and returns to the number of the starting position of the first text string from the first character of the second text string.
  • Substring – It represents the criteria.
  • Minus Operator (-) – This symbol will help to subtract any two values.
  • Comma symbol (,) – It is a separator that helps to separate a list of values.
  • Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

  • Here, we will enter the input text strings in Column B.
  • Now we are going to check the cell that contains specific text.
  • Select any cell and apply the above-given formula.
  • Finally, press ENTER to get the result out.

Bottom-Line:

Hope you like this article on how to test a cell that contains specific text in Excel. Please share your query below in the comment box. We will assist you.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Also:

14