Excel Formulas to Test If the Cell Contains Numbers ~ Quick Solution!!

Sometimes, you may want to check if a cell contains numeric characters. This tutorial provides a formula to test if the cell contains numbers in Excel. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

  • You can use the below formula to test if the cell contains numeric characters in Excel.

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

Syntax Explanations:

  • COUNT – This function helps to count the number of cells that contain numbers and returns the output in number. Read more on the COUNT Function.
  • FIND – The FIND Function helps to find out the location of the text and returns the position as a number.
  • A1 – It represents the input text strings.
  • Comma symbol (,) – It is a separator that helps to separate a list of values.
  • Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

  • Here, we will enter the input text values in Column B.
  • Now, we need to test if the cell contains numeric characters or not.
  • Select any cell and apply the above-given formula.
  • Finally, press ENTER to get the result out.

Closure:

Here, we have described the formulas to test if the cell contains numbers in Excel. I hope this helps. Feel free to ask back any questions and let us know how it goes. I will keep working with you until it’s resolved.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Related Articles:

18