Stripping the formatting out of a phone number
If you have a column of phone numbers all written in differently. As and example:
1234567890
123.456.7890
123-456-7890
123 456 7890
(123) 456.7890
(123)4567890
123 456789 0
How would you strip all of the formating out of the numbers so that it could be reformatted consistently?
In other words, how would you make the example above look like what's below?
1234567890
1234567890
1234567890
1234567890
1234567890
1234567890
1234567890
Numbers-OTHER, OS X Mountain Lion (10.8.2)