How can I check if a cell contains a number in Excel?

By /

To check if a cell contains a number in Excel, you can use the ISNUMBER function. This function checks if the value in a cell is a numerical value and returns either TRUE or FALSE. If the cell contains a number, the function will return TRUE, otherwise it will return FALSE. This function can be used in conjunction with other functions, such as IF, to perform specific actions based on the result. It is a useful tool for data analysis and can help identify numerical data in a spreadsheet.

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.

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:

x

Related terms:

  1. How to check if cell in Excel contains date value?
  2. How do I check if cell contains a partial text in Excel?
  3. How do I check if a cell contains text from a list in Excel?
  4. How to Check if Cell Contains Text from List in Google Sheets
  5. Another Cell How can I use conditional formatting in Google Sheets to highlight a cell if it is equal to or greater than another cell?
  6. Excel: Apply Conditional Formatting if Cell Contains Partial Text
  7. Excel: If Cell Contains Text then Return Value
  8. Excel: Apply Conditional Formatting if Cell Contains Formula
  9. Excel Formula: Replace If Cell Contains Specific Text
  10. What is Excel: Apply Conditional Formatting if Cell Contains Text