How to convert column names such as “AX” into a column number (without VBA)

You have a column designation such as “AX” in Excel and want to know how many columns this is – i.e. column 50? Then you don’t need a complicated formula or VBA code. It’s very easy with a little trick.

✅ The solution: SPALTE + INDIREKT

Simply enter the following formula in any cell:

=SPALTE(INDIREKT("AX1"))

🔍 What does the formula do?

• INDIREKT("AX1") creates a cell reference to the cell AX1.
• SPALTE(...) then returns the column number of this cell – in this case 50.

You can of course also use the formula dynamically, e.g. if the column name is in cell A1:

=SPALTE(INDIREKT(A1 & "1"))

👉 Example: If A1 contains the value “ZZ”, the result is column number 702.

💡 Why do you need it?

You need such conversions Conversions are the most important events and user actions on your website. For example, you can measure registrations, downloads and purchases as conversions in Google Analytics. mehr erfahren, for example, if you:

• work dynamically with cell ranges,
• merge data from different tables,
• create your own column numbering system,
• or are simply curious 😎

Dieser Beitrag ist auch verfügbar auf: Deutsch (German)