October 11, 200421 yr does anyone know how to build a calc that can go into a field and automatically extract the area code then paste the area code and phone number into seperate fields? Thanks in advance...
October 11, 200421 yr Depends on how the phone number is formatted. You use the text functions Left or Middle for the area code and the function Right for the rest.
Create an account or sign in to comment