I have a column of phone numbers that are all in different forms, such as:
555 123 4567
An maybe even a few more random forms. None of them ever have a 1 in front of area code, they all have 10 numbers.
Ultimately I need to run a Remove Duplicates from this column. I was thinking of creating a column right next to it that has all the phone numbers as 1234567890... just 10 numbers. Then running the remove duplicates from that column.
How would I get it to 123456790? The phone numbers are in column G.