Listing Alphabetic Letters in Excel

If you need a listing of the letters of the alphabet you can combine a couple of functions to provide the list.

In the image below you can see the CHAR function has been combined with the SEQUENCE function to provide a list of letters.

The formula in cell A1 is.

=CHAR(SEQUENCE(26,1,97))

This single formula spills down to list the 26 letters.

The CHAR function allows us to refer to characters using a code number. The lowercase letters start at code number 97 and the uppercase start at 65.

The SEQUENCE function allows us to create a list of sequential numbers. In this case 26 numbers that start at 97.

If you wanted a list of uppercase letters, you need to make a slight adjustment – see the image below.

The formula in cell B1 is.

=CHAR(SEQUENCE(26,1,65))

If you needed the listing horizontally see the images below.

The formula in cell C1 is.

=CHAR(SEQUENCE(1,26,97))

The formula in cell C2 is.

=CHAR(SEQUENCE(1,26,65))

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

2 thoughts on “Listing Alphabetic Letters in Excel

  1. A single formula to generate both sets of letters downward…

    =CHAR(SEQUENCE(26)+{96,64})

    and a single formula to generate both sets of letters across…

    =CHAR(SEQUENCE(,26)+{96;64})

    Note: The semi-colon is my Excel locale’s row delimiter inside of an array constant.