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? I'm a newbie, so please dumb down your answer. I just need the cell code. Thanks.
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? I'm a newbie, so please dumb down your answer. I just need the cell code. Thanks.