How to Check if Cell Contains Partial Text in Excel

To check if a cell contains partial text in Excel, you can use the SEARCH function in combination with the ISNUMBER function. This method will return TRUE if the specified text is found and FALSE if not found. Here's how to do it:

1. Open your Excel worksheet and identify the cell you want to check for partial text.
2. In an empty cell, enter the following formula:

   =ISNUMBER(SEARCH("text", A1))

   Replace "text" with the partial text you want to search for, and replace A1 with the cell reference you want to check.
3. Press Enter to apply the formula. The result will be TRUE if the cell contains the partial text and FALSE if it does not.
4. If you want to check for partial text in multiple cells, you can copy the formula and apply it to the other cells.

Example

Let's say we have the following data in column A, and we want to check if each cell contains the word "Excel":

A
1   Microsoft Excel
2   Excel tutorial
3   Word document
4   Excel tips

1. In cell B1, enter the following formula:

   =ISNUMBER(SEARCH("Excel", A1))

2. Press Enter to apply the formula. The result in B1 will be TRUE, as A1 contains the word "Excel".
3. Copy the formula in B1 and apply it to the cells B2 to B4 by dragging the fill handle down.

The final result will look like this:

A                 B
1   Microsoft Excel   TRUE
2   Excel tutorial    TRUE
3   Word document     FALSE
4   Excel tips        TRUE

Column B indicates whether the corresponding cell in column A contains the partial text "Excel".