How it works
A spreadsheet letters its columns A to Z, then AA, AB and on. This column letter to number converter gives a name's position, so AB is column 28.
Read the full guide
Letters in, number out
Type the letters from the top of the column, in capitals or small letters. Several names with commas or spaces between them are converted in one go: AB, AZ, ZZ gives 28, 52, 702.
The rule, for names past ZZ
Each letter counts as its place in the alphabet, A as 1 to Z as 26, and every step to the left is worth 26 times more. There is no zero, which is why AA follows Z. So AAA is 1 × 676 + 1 × 26 + 1 = 703.
- If your code counts columns from zero, take 1 off the answer: column AB is index 27.
Questions and answers
How do I convert a column letter to a number by hand?
For one letter, count its place in the alphabet. For two, multiply the first letter's place by 26 and add the second's: BC is 2 × 26 + 3 = 55.
What number is column AA?
27. Z is the 26th column, and after it the names start again with two letters, so AA is 27 and AB is 28.
How do I convert a column number to a letter?
Press Swap and type the number. By hand, divide by 26: the remainder is the last letter and the quotient is the letter in front. 55 is 2 remainder 3, so BC. A remainder of 0 means Z, with 1 taken off the quotient.