concantenate formula?

B

billygalkowski

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

JE McGimpsey

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

Gord Dibben

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
 
G

Gary''s Student

Say you data starts in A1. In B1 put:
=LEFT(A1,3)
and in C1 put:
=RIGHT(A1,7)
and copy down
 
Top