Excel Column Converter

Get instantly the number corresponding to a column letter (A=1, Z=26, AA=27...).

Column number: ?

Example: XFD corresponds to number 16384 (last column)

Excel column ? number is ?

Recent History

    How It Works

    Excel uses a sequential numbering system for its columns: A is the 1st, B the 2nd, ..., Z the 26th. Then, the sequence continues with AA (27th), AB (28th), and so on, working on a base-26 system.

    With this tool, you can also specify from which column you want to start counting. For example, if you start counting from B, column BR will equal 69 instead of 70. Leave empty or use "A" for absolute numbering.

    This tool performs this calculation for you, handling all valid columns up to the Excel limit (XFD = 16384). It's particularly useful for creating dynamic formulas (for example with the ADDRESS, INDIRECT or OFFSET functions) or for VBA programming.