# 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))``

### Related Posts

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

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

## 2 thoughts on “Listing Alphabetic Letters in Excel”

1. Rick Rothstein says:

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.

• Thanks again Rick – great use of the array syntax.