This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
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.
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
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? :)
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.
Thank you, Marcin! The second formula you provided worked, but I don't see a place to say this is the answer.
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
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".