How to get letter in alphabet based on number in Excel and Google Spreadsheet

Suppose you have a number between 1 and 26 in cell A1, you can get the corresponding letter in the alphabet using the following trick:

=mid("ABCDEFGHIJKLMNOPQRSTUVWXYZ";A1;1)

Of course, you can extend and modify this with your own letters to suit your particular needs.

4.1/5 - (71 votes)

From "aha" to "oh shit", I'm sharing everything on my journey of making the easiest website to learn Excel.

I'm learning a lot, and so will you.