View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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),M ID
(A1,3,1))&IF((ROW()26)*(ROW()<52),CHAR(CODE(MID(A 1,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.
.