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))
--
David Biddulph

"anand" wrote in message
...
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