How to Check if Cell Contains Number in Excel (With Example)


You can use the following formula in Excel to check if a given cell contains any numbers:

=COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A2))>0

This particular formula checks if cell A2 contains any numbers.

If it does, then the formula returns TRUE.

Otherwise, the formula returns FALSE.

The following example shows how to use this formula in practice.

Example: How to Check if Cell Contains Number in Excel

Suppose we have the following column of values in Excel:

Suppose that we would like to check if each cell in column A contains a number.

To do so, we can type the following formula into cell B2:

=COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A2))>0

We can then click and drag this formula down to each remaining cell in column B:

Excel check if cell contains number

Column B returns either TRUE or FALSE to indicate if the corresponding cell in column A contains a number.

For example:

  • Mavericks does not contain a number so the formula returns FALSE.
  • Hawks19 does contain a number so the formula returns TRUE.
  • 140Magic does contain a number so the formula returns TRUE.

And so on.

Note that if you’d like to know if the cell in column A only contains numbers, then you could type the following formula into cell B2 instead:

=ISNUMBER(A2)

We can then click and drag this formula down to each remaining cell in column B:

Each cell in column B returns TRUE if the corresponding cell in column A contains only numbers.

Otherwise, it returns FALSE.

Additional Resources

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

Excel: Check if Cell Contains One of Several Values
Excel: Check if Cell Contains Date
Excel: Calculate Average If Cell Contains Text

Leave a Reply

Your email address will not be published. Required fields are marked *