View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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.