2

I have a spreadsheet that has phone numbers in the cells that are typed out like this:

+1(313)313-3333

and I need these numbers to all be plain and look like this 3133133333 (with no 1 in front).

So I have a column of 200 phone number that all need to be edited and I do not want to edit by hand. How do I fix this?

0
=1*RIGHT(REGEXREPLACE(A2,"[^\d]",),10)
| improve this answer | |
  • 1
    This would be better if you expanded on how this solves the Asker's problem. – ale Feb 24 '18 at 15:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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