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

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.