We are trying to remove the leading 1 from the front of phone numbers, so that they just start with the area code.
For example, we get:
Is this possbile via a Regular Expression Dictionary?
I think I've got this one figured out for you, at least in 1 way. Someone else may reply with a better method, though!
The dictionary below does two steps, consecutively. First, it removes all non-digit characters from a phone number, such as parentheses and dashes. Then, it removes anything other than the last 10 digits of a phone number (area code + number). If you setup your dictionary exactly as it is displayed below, you should find success.
I've also attached a file that you can just copy and paste into a dictionary. Make sure to include the blank cells in Column A, because that is what is used to remove the extra elements in the phone number.
I hope this helpful, and good luck!
Here is another alternative one that might work well on business phones, it will strip any non-digits from the string, then remove the "1" if it is the first number in the string (will not remove other ones). I have also linked it here for easy copy/paste from excel: IgnoreFirstDigitif1.xlsx