Bulk Edit Phone Number Validation

All I want is to list out how many of each Area code I have. I have been trying to create a 3-digit area code field but this is a lot of manual (and or excel) work. If HubSpot has a “apply number formatting” and “Validated” flag then I should be able to sort my contacts by “validated = true” and so on.