I'm getting user submitted phone numbers in a variety of forms, for example (fictional):


I want to extract just the numbers so that I can upload them to an app that doesn't accept anything but numbers. How can I do that with a Google Sheets formula?

1 Answer 1


This function gets rid of all non-digit characters from cell A1 with REGEXREPLACE(). To avoid error when there's no non-digit character, the formula is wrapped with a fall-back IFERROR(). Output strings are then cast as a number with VALUE().


The output for the sample from above is:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.