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.