Convert number to alphabet letter in Excel and Google Sheets

=SUBSTITUTE(ADDRESS(1,A2,4),"1","")

A2 = data cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Convert number to alphabet letter in Excel

How to convert numbers to alphabet letters in Excel?
Convert number to alphabet letter in Excel

CONVERT NUMBER TO ALPHABET LETTER — EXCEL FORMULA AND EXAMPLE

=SUBSTITUTE(ADDRESS(1,A2,4),"1","")

  • A2 = data cell

Convert number to alphabet letter in Google Sheets

How to convert numbers to alphabet letters in Google Sheets?
Convert number to alphabet letter in Google Sheets

CONVERT NUMBER TO ALPHABET LETTER — GOOGLE SHEETS FORMULA AND EXAMPLE

=SUBSTITUTE(ADDRESS(1,A2,4),"1","")

  • A2 = data cell