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:


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

4.1/5 - (71 votes)