How fill cells with alpha series?

[inicholi]

in Excel 2007, how can the cells be filled with the alphabet? This sort uses
no numerals, strictly letters A to Z, then AA, AB, AC, ... ZZ. I guess like a
number system, base 26.

 

[Gord Dibben]

In A1 enter =SUBSTITUTE(ADDRESS(1,ROW(A1),4),"1","")

Copy down.

Excel 2003 will error out at row 257

Excel 2007 will error out at row 16385


Gord Dibben MS Excel MVP

 

[Rick Rothstein]

Here is a much shorter formula for you to use (instead of the previous
formula I posted)...

=IF(ROW(A1)<27,"",CHAR(64+INT((ROW(A1)-1)/26)))&CHAR(65+MOD(ROW(A1)-1,26))

To use this formula, put it in any cell more than 702 rows from the bottom
and copy it down for 702 rows...

 

[Rick Rothstein]

Hmm! I don't see my first posting in this thread (the one my second message
is supposed to be referring to). No matter... this formula is much better,
so don't worry about not being able to see my first formula attempt.