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?