Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |