Excel Formulas to Check If the Cells Contain Certain Text!!
Tags: excelformula, excelformulas
Published: 2021-02-16 07:02:26

---
title: Excel Formulas to Check If the Cells Contain Certain Text!!
published: true
date: 2021-02-16 04:35:51 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-check-if-cells-contain-certain-text/
---

One of the most comment tasks in Excel is to check whether a cell contains a specific value or not. You can use the IF function for solving this kind of problem. Here, I will introduce the simple formula to **check the cells that contain certain text in Excel**. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![If cells contains specific text](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/If-cells-contains-specific-text.png)](https://geekexcel.com/excel-formulas-check-if-cells-contain-certain-text/if-cells-contains-specific-text/#main)<figcaption id="caption-attachment-21912">If cells contain specific text</figcaption>
## Generic Formula:

- Use the below formula to test the cells that contain a specific text.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)([ISNUMBER](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)([SEARCH](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)(“abc”,A1)),A1,””)**

## Syntax Explanations:

- **IF** – In Excel, the **[IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** helps to return one value for a **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** result, and another for a **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** result.
- **ISNUMBER** – This function will return TRUE when a cell contains a number, and FALSE if there will not be a number. Read more on the **[ISNUMBER function](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)**.
- **SEARCH** – It 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. Read more on the **[SEARCH function](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)**.
- **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.

- First, we will enter the input values in **Column B**. Here we need to find the specific ID, that contains **“abc”.**

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Input-Range-3.png)<figcaption id="caption-attachment-21913">Input Range</figcaption>

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the **“Enter”** key.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Enter-the-formula-14.png)<figcaption id="caption-attachment-21914">Enter the formula</figcaption>

- Finally, we will get the results in the selected cell as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Result-16.png)<figcaption id="caption-attachment-21915">Result</figcaption>

## Wrap-Up:

From this short tutorial, we have described the simple steps used to find the text in the **cells that contain certain text in Excel**. Let me know if you have any **doubts** regarding this article or any other Excel/VBA topic. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Check the Values If Cells Begin with Given Criteria!!](https://geekexcel.com/excel-formula-if-cells-begin-with-given-criteria/)**
- **[Check If Cell Contains All Values from a Range in Excel Office 365!!](https://geekexcel.com/check-if-cell-contains-all-values-from-a-range-in-excel-office-365/)**