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.

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

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

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