How to Insert Alphabet in Excel

In Excel, in a very simple way you can generate the entire alphabet.

The formula

Just use a formula that you will learn in this article.

=CHAR(ROW()+CODE(“A”)-1)

=CHAR(ROW()+CODE(“a”)-1)

If you want to generate the alphabet in capital letters, type “A”.

If you want to generate a lowercase alphabet, type “a”.

Enter one of the following formulas into a cell and drag the cell via drag & drop.

Alphabet lowercase

Excel will automatically fill in the remaining letters of the alphabet for you.

Lowercase whole alphabet

Examples

If you drag beyond 26 cells, Excel will repeat the last letter of the alphabet for each additional cell. These signs are different for upper- and lowercase letters.

Charset after alphabet

This trick could be useful for developers and analysts who are dealing with alphabet or charset in spreadsheets.

See also  How to Increment Row Number in Excel Formula