How to un-format phone numbers

[JayBoston]

First spreadsheet: I have a spreadsheet with thousands of phone numbers on it. The phone numbers are formatted with dashes: 555-555-1212 I need to remove the dashes so the phone numbers look like this: 5555551212

Second spreadsheet: I have a second spreadsheet with phone numbers formatted with a "1" in front of all the phone numbers: 15555551212 i want to remove the 1's to make the phone numbers look like this: 5555551212

How?

 

[shg]

For the first, find and replace hyphens with nothing.

For the second,

	A​	B​	C​
1​	15555551212​	5555551212​	B1: =MOD(A1,10000000000)