Column Letter to Number Converter

Convert a spreadsheet column letter to its number, or a number to its letter. For example, column AA is number 27 and column XFD is number 16384. Everything runs in your browser.

Do it inside your sheet

Letter to number: =COLUMN(INDIRECT("AA1"))

Number to letter: =SUBSTITUTE(ADDRESS(1,27,4),"1","")

Formulas tested in Google Sheets on November 9, 2026. In locales that use a semicolon as the argument separator, replace each , with ;.

How column letters work

Columns are numbered like a base-26 system without a zero: A to Z are 1 to 26, then AA is 27, AZ is 52, BA is 53 and ZZ is 702. Three-letter columns start at AAA, which is 703.

When you need the column number

Several Google Sheets functions ask for a column as a number, not a letter, so converting is a common step:

  • VLOOKUP needs the position of the column to return, counted from the first column of the range. In =VLOOKUP(A2, B:F, 3, FALSE), the 3 means column D, the third column of B:F.
  • INDEX and OFFSET take row and column numbers, for example =INDEX(A1:AD100, 5, 27) returns the value in AA5, the 27th column of the range.
  • ADDRESS builds a cell reference from numbers, which is how the number-to-letter formula below works.
  • QUERY refers to columns as Col1, Col2, Col3 and so on when the data comes from an array or another function (for example =QUERY({A1:C10}, "select Col2")), so you need to know their numbers.

Do it with a formula

  • Letter to number: =COLUMN(INDIRECT("AA1")) returns 27. Replace AA with your letter.
  • Number to letter: =SUBSTITUTE(ADDRESS(1,27,4),"1","") returns AA. Replace 27 with your number.

In locales that use semicolons between arguments, write =SUBSTITUTE(ADDRESS(1;27;4);"1";"").

The formulas on this page were last tested in Google Sheets on November 9, 2026.