I am trying to figure out if I can use a Macro to do a couple of things to a phone number column:

1. Remove all non-numeric characters
2. Remove all entries that are less than 10 digits
3. Remove the country code (1) from the beginning of all numbers and remove any extension numbers from the end of all numbers
4. Remove all entries that are 'fake' phone numbers (i.e. 0000000000 or 3171234567)

This may be too much to do for one macro but if I can get some help with any of those 4 parts I'd appreciate any help on any part of this.