concantenate formula?

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 <5915164f33424@uwe>, "billygalkowski" <u16801@uwe> 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!

Select the column.

Then Data>Text to Columns>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, "billygalkowski" <u16801@uwe> 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!

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