I have a column of phone numbers that are 10 or 11 digits. Currently they are formatted as text. Some phone numbers have a 1 in the front, some do not.
How can I take the 1 out of the phone numbers that have it? That way they are are consistently 10 digits.