Assume the number you want to separate is in cell a1 and you want to
separate it into b1, c1, d1 and e1. The following formulas will do it:

in b1, use =left (a1,1)
in c1, use =mid (a1,3,1)
in d1, use =mid (a1,5,3)
in e1, use =right(a1,3)

Fill these columns down and you'll distribute all the numbers in column a
across b, c, d, and e.

Chuck