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

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