Converting various phone number formats

  • Thread starter Thread starter Sean
  • Start date Start date
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
 
Back
Top