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

J

Jason

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?
 
R

RagDyeR

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


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?
 
R

Roger Govier

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
 
Top