View Single Post
  #4   Report Post  
N Harkawat
 
Posts: n/a
Default

Type the number 65 on cells A1, B1, and on cell C1

on cell A2 type
=IF(MOD(ROW()-1,676)=0,A1+1,A1)
on cell B2 type
=IF(MOD(ROW()-1,676)=0,65,IF(MOD(ROW()-1,26)=0,B1+1,B1))
on cell C2 type
=IF(MOD(ROW()-1,26)=0,65,C1+1)
on cell d2 type
=CHAR(A2)&CHAR(B2)&CHAR(C2)

And now copy the range A2:D2 and paste all the way through cells A17576 (the
total possible outcomes = 26 ^ 3 =17,576)

Column D is your result.
You can now copy and paste special -values - column D to eliminate the
formulas if you need to do so




"dogisnuts" wrote in message
...
I want excel to auttofill an alphabetic sequence. AAA, AAB, AAC, etc. all
the way to ZZZ.