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 *!! **