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!

concantenate formula?
 

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!

concantenate formula?
 

Select the column.

Then DataText to ColumnsFixed 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!

concantenate formula?
 

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!