Converting various phone number formats

S

Sean

I have a database with manually entered phone numbers. I
need to convert all of the phone numbers to 10 digit
numbers with no "-" or (). Here is an example:

(214) 555-1212 to 2145551212
817-555-3433 8175553433
3243433434 3243433434
(512)555-0909 5125550909

Could you give me the formula to perform the conversion?

Thanks,

Sean
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Here we are with the phone numbers again. I need to convert 7
Extract phone number from word file 2
Multiple formats in one cell 1
Phone number format on numbers with Extensions 3
How can I display symbols in phone # formatted cell when empty? 1
formatting a phone number in a string 2
Formatting Phone Numbers in Excel 2007 Help 16
Date & Phone Manipulation 2

Top