splitting cell

[Guest]

Can anyone tell me how to split a 7 or 8 digit number in a cell so that each
individual digit is in a separate cell on the same row (with margin to right
i.e. the right hand most #'s should line up).

Thanks

anand

 

[Guest]

if A1 contains 12345678
then in B1 thru I1, enter:
=MID($A$1,COLUMN()-1,1)

 

[David Biddulph]

If your data value is in A1, then try this in columns B to I:
=IF(COLUMN()+LEN($A1)<10,"",--MID($A1,COLUMN()+LEN($A1)-9,1))