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.
|