Check if Cell Contains Specific Number – Excel & Google Sheets
In this Article
This tutorial demonstrates how to check if a cell contains a specific number using the FIND and ISNUMBER Functions in Excel and Google Sheets.
Check if Cell Contains Specific Number Using ISNUMBER and FIND
A cell that contains a mix of letters, numbers, spaces, and/or symbols is stored as a text cell in Excel. We can check if one of those cells contains a specific number with the ISNUMBER and FIND Functions.
1 |
=ISNUMBER(FIND(9,B3)) |
Let’s step through this two-part formula.
The FIND Function
First, the FIND Function checks for a specified character within a text string. It then returns the position of that character in the string, or a VALUE error if it is not found.
1 |
=FIND(9,B3) |
In this example, the FIND Function returns the position of “9” in each cell. As shown above, for cells without the number 9, it returns a VALUE error.
Note: You can use either the FIND or SEARCH Function to check if a cell contains a specific number. Both functions have the same syntax and, with numeric find texts, produce the same result.
The ISNUMBER Function
Next, the ISNUMBER Function does what its name implies: it checks if a cell is a number and returns TRUE or FALSE.
1 |
=ISNUMBER(C3) |
The ISNUMBER Function checks the result of the FIND Function and returns TRUE for cells with position numbers and FALSE for the cell with a VALUE error.
Combining these functions together gives us our original formula:
1 |
=ISNUMBER(FIND(9,B3)) |
Check if Cell Contains Specific Number in Google Sheets
These functions work the same in Google Sheets as in Excel.