Incementing alpha characters in Excel? 1

[Apollo6]

In cell "A1", I have "AAA". I want to populate down column "A" incrementing the original value as follows:

A1 = AAA
A2 = AAB
A3 = AAC

Once it reaches "AAZ" the next cell should be "ABA" as follows:

A27 = ABA
A28 = ABB
A29 = ABC

And so on...

Ultimately, I am looking for an alpha 3-character code starting with "AAA". If this is not the best way to go about this I am open for suggestions. Any suggestions or help would be greatly appreciated.

 

[SkipVought]

Hi,

You don't really need VB code

or

you could code a solution from this spreadsheet example
[tt]
=CHAR(65+MOD(INT((ROW()-1)/26^2),26^2))&CHAR(65+MOD(INT((ROW()-1)/26),26))&CHAR(65+MOD(INT((ROW()-1)),26))[/tt]

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[Apollo6]

I wasn't sure if it was a VB loop of sorts or not. That formula is awesome! Thanks a ton!!!

 

[SkipVought]

slight correction...
[tt]
=CHAR(65+MOD(INT((ROW()-1)/26^2),26))&CHAR(65+MOD(INT((ROW()-1)/26^1),26))&CHAR(65+MOD(INT((ROW()-1)/26^0),26))
[/tt]

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[SkipVought]

Of course you could write a program instead of pasting the formula into a column. ;-)

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}