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.

  • Flemming Steffensen

    The CHAR() command is much better suited for this. It indexes the ASCII table directly

    For big letters use this formula:

    … and for small letters use this:

    • Hi Flemming, thanks for your valuable addition! I was under the impression that using CHAR would be dependent on the spreadsheet’s locale settings which is why I opted for this work-aroundy, expressive option. But seeing it takes the ASCII table that shouldn’t be a problem, right?

      The advantage of my proposed expressive workaround would be when you want to easily modify your ‘alphabet’. I’ll update my post later to include your option as well.

      • Flemming Steffensen

        Using CHAR() may in some cases be dependent on the local settings, but not for the English alphabet and numbers etc.
        Since CHAR() uses a potential local variant of the ASCII table, entries after 128 may differ, but the first 127 entries are standardized – refer to for the list.

  • Huppe

    For columns more than Z – ZZ use this: