How do I split one cell of 6 numbers into two cells of 3 and 3?
 

I have a column of data that has six numbers in each cell, however I need to
split this into two columns, where the first column is the first three digits
and the second column is the last three. There is no separator (space, comma
or dash) between the numbers. Any suggestions?

Use Text To Columns.

Select your column of data, then:
<Data <TextToColumns

Click "Fixed Width", then <Next,

Click in the data to display the "break line", and drag it to separate the
numbers as desired.
Then <Finish
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Jason" wrote in message
...
I have a column of data that has six numbers in each cell, however I need to
split this into two columns, where the first column is the first three
digits
and the second column is the last three. There is no separator (space,
comma
or dash) between the numbers. Any suggestions?

Assuming the data to be in column A
in B1=LEFT(A1,3)
in C1=RIGHT(A1,3)

If you want the results as numeric, then put *1 at the end of each formula.
Copy down the range required

--
Regards
Roger Govier
"Jason" wrote in message
...
I have a column of data that has six numbers in each cell, however I need
to
split this into two columns, where the first column is the first three
digits
and the second column is the last three. There is no separator (space,
comma
or dash) between the numbers. Any suggestions?