Fill Series

[JonA2]

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.

 

[David Biddulph]

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" <[email protected]> wrote in messageStarting 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.

 

[Gord Dibben]

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