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
    This would be better if you expanded on how this solves the Asker's problem. – ale Feb 24 '18 at 15:10

Your Answer

