Say you data starts in A1. In B1 put:
=LEFT(A1,3)
and in C1 put:
=RIGHT(A1,7)
and copy down
--
Gary's Student


"billygalkowski" wrote:

I havea few thousand 10 digit phone numbers all in one column. I need to
separate these into two columns with the area code in one column and the
remaining 7 digit phone number in the other column.

How do I do this? What is the formula?? Can anyone help me?! THANKS and
HAPPY HOLIDAYS!