Dealing With Alphabet

In Excel, in a very simple way you can generate the entire alphabet. 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 inserts all letters of the alphabet.

Lowercase whole alphabet

If you drag more than 26 cell, Excel will insert only the letter.

If you drag exactly 26 cell, Excel will insert through the entire alphabet.

If you drag more than 26 cell, Excel will insert other trademarks charset. 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.


You can download the Template here – Download