Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to autofill excel with an alphabetic sequence (aaa, aab, etc.. | Excel Discussion (Misc queries) | |||
Autofill from column to row | Excel Discussion (Misc queries) | |||
AutoFill Visible Cells with Months | New Users to Excel | |||
autofill macro | Excel Discussion (Misc queries) | |||
Formula for copying a sequence for every 8th cell | Excel Worksheet Functions |