I am looking to divide the items in a cell into to two new cells with one
having the first five digits and the second cell to have the balance

Under Data choose text to columns. Or if you would prefer using formulas =left(A1,5) in your first new column and =mid(A1,6,200) in your next column you can substitute any number for the 200 to sufficently include all your data.

You could use Data | Text to Columns
OR
Suppose A1 holds a 9 digit number such as 123456789, then in B1
=INT(A1/10000) gets you 12345 while =A1-B1*10000 returns 6789.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"RobBB&B" wrote in message
...
I am looking to divide the items in a cell into to two new cells with one
having the first five digits and the second cell to have the balance

Try Data TextToColumns Fixed and set the column line to separate the
text at the 5 character point.....

hth
Vaya con Dios,
Chuck, CABGx3



"RobBB&B" wrote:

I am looking to divide the items in a cell into to two new cells with one
having the first five digits and the second cell to have the balance