| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How fill cells with alpha series?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How fill cells with alpha series?
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 On Sat, 25 Jul 2009 09:10:01 -0700, inicholi wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How fill cells with alpha series?
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. -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
| auto fill series between to non-adjacent cells | Excel Discussion (Misc queries) | |||
| How to fill cells with a different kind of series? | Excel Worksheet Functions | |||
| how do i fill down a series of linked cells | Excel Discussion (Misc queries) | |||
| Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
Linear Mode
