You can use the following formula to remove non-numeric characters from cells in Google Sheets:
=REGEXREPLACE(A2,"D+", "")
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:
=REGEXREPLACE(A2,"D+", "")
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.
Additional Resources
The following tutorials explain how to perform other common operations in Google Sheets:
How to Extract Substring in Google Sheets
How to Reverse a Text String in Google Sheets
How to Extract Numbers from String in Google Sheets