Delimited Numbers

Hi Friends,

i have large numbers in Column A and i delimited it by column B To H.
eg. 1452689 will be delimited 7 columns 1 4 5 2 6 8 9

maximum digit will be 7 in column A
if a number like 456 comes in Column A the it will be delimited like this 4 5 6 in column F to G
means right alignment

Please see the attached file for more details

Hi check such code

Please Login or Register  to view this content.

Or this formula (which doesn't use the delimiting) - J6 copied over and down:

=MID(TEXT($A2,"0000000"),COLUMNS($J:J),1)*1

you can suppress the leading zero results (if they are not wanted) with this version (also in J6 and copied over and down):

=IF(LEN($A2)>=COLUMNS(J:$P),MID(TEXT($A2,"0000000"),COLUMNS($J:J),1)*1,"")
or
=IF(LEN($A2)<COLUMNS(J:$P),"",MID(TEXT($A2,"0000000"),COLUMNS($J:J),1)*1)