You can use the following formula in Excel to determine if a cell contains a certain string:

=IF(ISNUMBER(SEARCH("this",A1)), "Yes", "No")

In this example, if cell **A1** contains the string “**this**” then it will return a **Yes**, otherwise it will return a **No**.

The following examples show how to use this formula in practice.

**Example: Check if Cell Contains a Certain String in Excel**

Suppose we have the following dataset in Excel that shows the number of points scored by various basketball players:

We can use the following formula to check if the value in the Team column contains the string “mavs”:

=IF(ISNUMBER(SEARCH("mavs",A2)), "Yes", "No")

We can type this formula into cell **C2** and then copy and paste it down to the remaining cells in column C:

The three rows with a value of “mavs” in the Team column all receive a **Yes** in the new column while all other rows receive a **No**.

Note that the **SEARCH()** function in Excel is case-insensitive.

If you’d like to perform a **case-sensitive** search, you can swap out the **SEARCH()** function in the formula with the** FIND()** function.

For example, we could use the following formula to check if any value in the Team column is equal to “MAVS”:

=IF(ISNUMBER(FIND("MAVS",A2)), "Yes", "No")

The following screenshot shows how to use this formula in practice:

Notice that every value in the new column is equal to **No** because none of the team names match the uppercase “MAVS” string that we specified in the formula.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

How to Count Duplicates in Excel

How to Count Frequency of Text in Excel

How to Calculate Average If Cell Contains Text in Excel

How to fetch the string ‘Mavs’ after identifying as ‘tes’?