How can I setup, auto fill of data in Excel. For Eg: I want to start from
AAAAA and finisz with ZZZZZ, and let the program generate, everything in
between, but in sequance. AAAAA, AAAAB, AAAAC, AAAAD etc.etc.
How can I setup, auto fill of data in Excel. For Eg: I want to start from
AAAAA and finisz with ZZZZZ, and let the program generate, everything in
between, but in sequance. AAAAA, AAAAB, AAAAC, AAAAD etc.etc.
Not sure if this is the sequence you're looking for, but
put AAAAA into cell A1, then put this in A2 and fill down
to row 129:
=IF(ROW()>104,CHAR(CODE(LEFT(A1))+1),LEFT(A1))&IF((ROW()
>78)*(ROW()<104),CHAR(CODE(MID(A1,2,1))+1),MID(A1,2,1))&IF
((ROW()>52)*(ROW()<78),CHAR(CODE(MID(A1,3,1))+1),MID
(A1,3,1))&IF((ROW()>26)*(ROW()<52),CHAR(CODE(MID(A1,4,1))
+1),MID(A1,4,1))&IF(ROW()<=26,CHAR(CODE(RIGHT(A1))
+1),RIGHT(A1))
HTH
Jason
Atlanta, GA
>-----Original Message-----
>How can I setup, auto fill of data in Excel. For Eg: I
want to start from
>AAAAA and finisz with ZZZZZ, and let the program
generate, everything in
>between, but in sequance. AAAAA, AAAAB, AAAAC, AAAAD
etc.etc.
>.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks