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.

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.

Now your alphabet numbering formula is ready.
Leave a Reply