Formula to Generate AAAAA to ZZZZZ

[EmeraldCheetah]

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

[shg]

Row\Col	B
2	AAAAA
3	AAAAB
4	AAAAC
26	AAAAY
27	AAAAZ
28	AAABA

In B2:

= CHAR(MOD(INT((ROWS(B$1:B2)-2)/26^4), 26) + 65)
& CHAR(MOD(INT((ROWS(B$1:B2)-2)/26^3), 26) + 65)
& CHAR(MOD(INT((ROWS(B$1:B2)-2)/26^2), 26) + 65)
& CHAR(MOD(INT((ROWS(B$1:B2)-2)/26^1), 26) + 65)
& CHAR(MOD(INT((ROWS(B$1:B2)-2)/26^0), 26) + 65)

[EmeraldCheetah]

Thanks! That got me what i needed!

[shg]

You're welcome.