Download the example workbook
This tutorial will demonstrate how to convert a column number to its corresponding letter in Excel.
The formula above returns the column letter in the position of the number in the referenced cell.
Let’s walk through the above formula.
The ADDRESS Function
First, we will use the ADDRESS Function to return a cell address based on a given row and column.
Important! You must set the [abs_num] input to 4, otherwise the cell address will display with $-signs.
The SUBSTITUTE Function
Next, we use the SUBSTITUTE Function to replace the row number “3” with a blank string of text (“”) leaving only the column letter.
Putting the functions together results to the initial formula, which converts the column numbers into letters.
Convert Column Number to Letter in Google Sheets
These formulas work exactly the same in Google Sheets as in Excel.