How fill cells with alpha series?

  • Thread starter Thread starter inicholi
  • Start date Start date
I

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.
 
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
 
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...
 
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.
 
Back
Top