Convert Column Letter to Number – Excel & Google Sheets

This tutorial demonstrates how to convert a column letter to number in Excel.

Convert Column Letter to Number Main Function

Converting Column Letter to Number

To get the number of a column letter in Excel, we will use the COLUMN and INDIRECT Functions.

LETTER TO NUMBER

INDIRECT Function

The INDIRECT Function converts a string of text corresponding to a cell reference, into the actual cell reference.

Indirect

COLUMN Function

The cell reference is then passed to the COLUMN Function, which returns the number of the column.

To illustrate, let’s see some examples below.

=COLUMN(A1) has a result of 1.  This is because the cell reference “A1” is in column number 1.

=COLUMN(B1) has a result of 2.  This is because the cell reference “B1” is in column number 2.

=COLUMN(H1) has a result of 8.  This is because the cell reference “H1” is in column number 8.

REF 02 EX 01

REF 02 EX 02

Convert Column Letter to Number in Google Sheets

The combination of COLUMN and INDIRECT Functions works exactly the same in Google Sheets as in Excel:

Convert Column Letter to Number Go

 

 

Excel Practice Worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!