phone number trick

[bsacco]

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...

[RalphL]

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.