How to create a list of the alphabet starting with AA in Excel

Question

How to create a list of the alphabet starting with AA in Excel

Dee Cee 20

Hello - I need to create a list in Excel starting with AA - CZ and I'd rather not type them out. Is there a formula or function to do this?

AA

AB

AC

AD

......CZ

0 comments

5 answers

Your answer

Answer 1

Marcin Policht 89,240 MVP Volunteer Moderator

Apologies - clearly I missed that - try the following instead:

=CHAR(65+INT((ROW(A1)-1)/26)) & CHAR(65+MOD(ROW(A1)-1,26))

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin

Jiajing Hua 18,175 Reputation points Moderator

2025-02-03T08:29:43.94+00:00

Hi @Dee Cee

I am glad that your issue is resolved.

Here, I would also like to thank Marcin Policht for the contribution to this issue.

In order to make it easier for you to find the button to accept the answer, I converted Marcin Policht 's comment as an answer.

If you have any issues on "Accept Answer", please feel free to let us know.

Answer 2

Marcin Policht 89,240 MVP Volunteer Moderator

Try entering

=CHAR(65+INT((ROW(A1)-1)/26)) & CHAR(65+MOD(ROW(A1)-1,26))

in the first cell and then drag it down...

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin

Jiajing Hua 18,175 Reputation points Moderator

2025-01-29T02:41:53.46+00:00

Hi @Dee Cee

Please check Marcin Policht's great formula.

Any further issues, you may post back.
Dee Cee 20 Reputation points

2025-01-29T18:10:14.5233333+00:00

Hi Marcin - thank you so much for replying to my question! When I enter your formula with AA as my starting point, it gives me BB, BC, BD, BE, and so on. I'd like it to give me AB, AC, AD, AE, AF, all the way down to CZ. At AZ, it should start with BA, BB, BC, BD. Can your formula be adjusted to do that? :)
Dee Cee 20 Reputation points

2025-01-29T19:59:58.6766667+00:00

Hi Marcin - thank you for the formula, it does some of what I want.

When I enter exactly as written, with AA in cell A1 and copying down, it gives me BB, BC, BD, BE to BZ, which then goes to CA, CB, CC correctly, so it's just not giving me the AB, AC, AD, AE.
Dee Cee 20 Reputation points

2025-01-31T15:36:22.36+00:00

Thank you, Marcin! The second formula you provided worked, but I don't see a place to say this is the answer.
Marcin Policht 89,240 Reputation points MVP Volunteer Moderator

2025-01-31T16:57:43.2533333+00:00

You're welcome. You should be able to follow https://learn.microsoft.com/en-us/answers/support/accept-answer#accept-an-answer

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin

Answer 3

IlirU 2,251 Volunteer Moderator

User's image

Hi,

In any cell you want, you can apply this formula:

=SUBSTITUTE(ADDRESS(1, SEQUENCE(78,, 27), 4), 1, "")

HTH

0 comments

Answer 4

Ashish Mathur 101.8K Volunteer Moderator

Hi,

In cell A2, enter this formula

=LET(s,SEQUENCE(78)-1,CHAR(INT((s)/26)+65)&CHAR(MOD(s,26)+1+64))

Hope this helps.

User's image

0 comments

Answer 5

riny 20,870 Volunteer Moderator

Just for the sake of showing an alternative that works in modern Excel.

=TOCOL(CHAR(SEQUENCE(3,,65))&TRANSPOSE(CHAR(SEQUENCE(26,,65))))

This will spill a dynamic array (1 column, 78 rows) starting with "AA" and finishing with "CZ".

Dana 10 Reputation points

2025-08-07T01:47:02.69+00:00

Can't seem to delete my post.

~~A slightly more efficient way is..~~

Share via

How to create a list of the alphabet starting with AA in Excel

5 answers

Your answer