Lesson#154: How to make Alphabet numbering formula in Excel

Puspendu Roy Karmakar Posted on June 20, 2022 Posted in Excel Tricks No Comments Tagged with CHAR, ROW

Here I shall show you to make alphabet numbering formula. Like A, B, C, D…. or a, b, c, d….

Before starting that I want you to memorise that in ASCII code A starts from 65 and a starts from 97.

Here I shall use a simple formula to start numbering from A.

=CHAR(65+ROW()-2)

You may ask why ROW()-2 ?

Because in 2nd row of spreadsheet =ROW()-2 = 0

I have used it to automate the formula when we drag down it.

Similarly I shall use this formula to start numbering with a.

=CHAR(97+ROW()-2)

Now your alphabet numbering formula is ready.

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.