You can use the following formula to remove non-numeric characters from cells in Google Sheets:
This particular formula will remove all non-numeric characters from cell A2.
Example: Remove Non-Numeric Characters from Cell in Google Sheets
Suppose we have the following list of phone numbers in Google Sheets:
Now suppose that we would like to remove all non-numeric characters from each phone number so that we’re only left with the numbers.
We can use the following formula to do so:
We’ll type this formula in cell B2, then drag and fill it down to each remaining cell in column B:
Notice that each non-numeric character has been removed from each phone number.
In particular, the parentheses and the dashes have been removed from each phone number.
Note: You can find the complete documentation for the REGEXREPLACE function here.
The following tutorials explain how to perform other common operations in Google Sheets: