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?

......CZ

1 answer

Marcin Policht 32,975 Reputation points MVP

2025-01-28T23:55:45.9233333+00:00

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
Please sign in to rate this answer.

1 person found this answer helpful.
Jiajing Hua-MFST 13,860 Reputation points Microsoft Vendor

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.

Marcin Policht 32,975 Reputation points MVP

2025-01-29T20:33:13.5166667+00:00

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
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

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

1 answer

Your answer