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


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?


1 Answer 1

  • 2
    This would be better if you expanded on how this solves the Asker's problem.
    – ale
    Feb 24, 2018 at 15:10

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.