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 (81.45%) 69 votes