Excel Formulas Check the Cell Contains Some Words but Not Others!!

Excel allows its users to find out if the cell contains some words but not others. It is equipped with functions that enable a user to validate the presence of a specified word in a cell. Let’s get 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:

  • If you test a cell if contains certain words but not others, you can use the below formula.

=AND(COUNT(SEARCH(include,A1))>0,COUNT(SEARCH(exclude,A1))=0)

Syntax Explanations:

  • AND – 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 AND Function.
  • COUNT – The COUNT Function counts the number of cells that contain numbers and returns the output in number.
  • *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.
  • *A1 * – It represents the input text strings.
  • Include – It specifies the criteria that help to check the cell value.
  • Exclude – It represents the excluding values.
  • 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.

Example:

Refer to the below example image.

  • Here, we will enter the input text strings in Column B.
  • Now we are going to check a cell to see if contains certain words but not others.
  • Select any cell and apply the above-given formula.
  • Finally, press ENTER to get the result out.

Conclusion:

From this tutorial, we have discussed the simple formulas to test a cell that contains certain words but not others in Excel. If you have any other ideas or question , do share with us here in the comments section below.

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

Read Also:

11