2 Replies Latest reply: Nov 16, 2012 5:02 PM by Mike2Simpson
Mike2Simpson Level 1 Level 1 (0 points)

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, OS X Mountain Lion (10.8.2)