From AAA to ZZZ
Oops, misread your start-point (AAA, not A) ! <g
Put in any starting cell, say, B2:
=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)))
Copy B2 down to B17577
(i.e. down by 17576 rows [26^3=17576])
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
|