ExcelBanter - Fill Series

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Fill Series (https://www.excelbanter.com/excel-discussion-misc-queries/208241-fill-series.html)

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.

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.

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.