How fill cells with alpha series?
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 (MVP - Excel)
"inicholi" wrote in message
...
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.
|