I found the below formula to generate a list of AAA to ZZZ. I need to generate all the possibilities for 5 alpha characters from AAAAA to ZZZZZ. I cannot figure out the syntax to modify this formula to add two more characters.
In cell B2(Drag formula down for list):
=UPPER(IF(ROW(A703)>18278,CHAR(96+INT(MOD(ROW(A703)-18279,456976)/17576)+1),
"")&IF(ROW(A703)>702,CHAR(96+INT(MOD(ROW(A703)-703,17576)/676)+1),"")&IF(ROW(A703)>26,CHAR(96+INT(MOD(ROW(A703)-27,676)/26)+1),"")&CHAR(97+MOD(ROW(A703)
-1,26)))
Bookmarks