Quote:
|
Originally Posted by RobBB&B
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.