Check If Cells in Excel Contain any Text

Sometimes you may want to check if cells in a worksheet contain any text. This tutorial shows you a technique for checking if cells in Excel contain any text.

How to Check If Cells in Excel Contain Any Text

We can use a formula that combines the IF and the ISTEXT functions to check if cells in Excel contain any text. We will use the following sample dataset in our illustration. We want the formula to return “Yes” if a cell contains a text value or “No” if the cell does not contain a text value.

Table

Description automatically generated

We use the steps below:

  1. Select cell B2 and enter the following formula:
Graphical user interface, application, table, Excel

Description automatically generated
  1. Press the Enter key on the keyboard or click the Enter button on the formula bar:
Graphical user interface, application

Description automatically generated
  1. Double-click or drag down the fill handle to copy the formula down the column:
Table

Description automatically generated

Explanation of the formula

  • ISTEXT(A2). In this part of the formula, the ISTEXT function checks whether the value in cell A2 is text and returns “FALSE” because the value in cell A2 is not text but a number.
  • The formula then becomes =IF(FALSE, “Yes“, “No“) and the IF function returns “No“.

Conclusion

At times we may want to check if cells in Excel contain any text. This tutorial showed how to use a formula that combines the IF and ISTEXT functions to check if cells in Excel contain text.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.