software

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!

Try Data/Text to Columns. Click the Fixed width radio button, then Next.
Click between the 3rd and 4th number. Click Finish.

In article lt;5915164f33424@uwegt;, quot;billygalkowskiquot; lt;u16801@uwegt; wrote:

gt; I havea few thousand 10 digit phone numbers all in one column. I need to
gt; separate these into two columns with the area code in one column and the
gt; remaining 7 digit phone number in the other column.
gt;
gt; How do I do this? What is the formula?? Can anyone help me?! THANKS and
gt; HAPPY HOLIDAYS!

Select the column.

Then Datagt;Text to Columnsgt;Fixed Width.

Select the three digits on the left and Finish.

Make sure you have an empty column to the right of the data before splitting.Gord Dibben Excel MVP

On Mon, 19 Dec 2005 20:02:49 GMT, quot;billygalkowskiquot; lt;u16801@uwegt; wrote:

gt;I havea few thousand 10 digit phone numbers all in one column. I need to
gt;separate these into two columns with the area code in one column and the
gt;remaining 7 digit phone number in the other column.
gt;
gt;How do I do this? What is the formula?? Can anyone help me?! THANKS and
gt;HAPPY HOLIDAYS!

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

gt; I havea few thousand 10 digit phone numbers all in one column. I need to
gt; separate these into two columns with the area code in one column and the
gt; remaining 7 digit phone number in the other column.
gt;
gt; How do I do this? What is the formula?? Can anyone help me?! THANKS and
gt; HAPPY HOLIDAYS!
gt;