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

Dee Cee 20 Reputation points
2025-01-28T22:57:43.3833333+00:00

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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,165 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Marcin Policht 35,835 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

    2 people found this answer helpful.

  2. Marcin Policht 35,835 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

    1 person found this answer helpful.

  3. riny 260 Reputation points
    2025-02-03T12:50:18.23+00:00

    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".

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.