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:

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