Convert Column Number to Letter – Excel & Google Sheets

This tutorial will demonstrate how to convert a column number to its corresponding letter in Excel.

convert column number to letter Main Function

To convert a column number to letter we will use the ADDRESS and the SUBSTITUTE Functions.

CONVERT TO LETTER

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.

ADDRESS

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.

SUBSTITUTE

Putting the functions together results to the initial formula, which converts the column numbers into letters.

Please note that any number can be used as the row number within the ADDRESS Function as long as you enter the same row number into the SUBSTITUTE Function.

AutoMacro - VBA Code Generator

Convert Column Number to Letter in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel.

convert column number to letter Google Function

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!