| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Series
Starting with AAA, does anyone have the "short" formula to get a row to
"fill" with AAB, AAC etc etc (needing about 400 in sequence). Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fill Series
There may be an easier way, but try
=CHAR(MOD((COLUMN()-1)/(26*26),26)+65)&CHAR(MOD((COLUMN()-1)/26,26)+65)&CHAR(MOD(COLUMN()-1,26)+65)--David Biddulph"JonA2" wrote in ... Starting with AAA, does anyone have the "short" formula to get a row to "fill" with AAB, AAC etc etc (needing about 400 in sequence). Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fill Series
For versions of Excel earlier than 2007 which are limited to 256 columns,
try David's edited formula copied down a column 400 rows =CHAR(MOD((ROW()-1)/(26*26),26)+65)&CHAR(MOD((ROW()-1)/26,26)+65)&CHAR(MOD(ROW()-1,26)+65) Gord Dibben MS Excel MVP On Wed, 29 Oct 2008 20:18:42 -0000, "David Biddulph" <groups [at] biddulph.org.uk wrote: There may be an easier way, but try =CHAR(MOD((COLUMN()-1)/(26*26),26)+65)&CHAR(MOD((COLUMN()-1)/26,26)+65)&CHAR(MOD(COLUMN()-1,26)+65)--David Biddulph"JonA2" wrote in ... Starting with AAA, does anyone have the "short" formula to get a row to "fill" with AAB, AAC etc etc (needing about 400 in sequence). Thanks. |
| 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) | |||
| Fill series | Excel Discussion (Misc queries) | |||
| fill series | Excel Discussion (Misc queries) | |||
| fill series | New Users to Excel | |||
| Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
Hybrid Mode
