Excel - Column Number to Column Name Converter and Column Name to Column Number Converter
Formula for converting Excel Column Number to Column Name (Column Number specified in B1): =SUBSTITUTE(ADDRESS(2, B1, 4), "2", "") Formula for converting Excel Column Name to Column Number (Column Name specified in B2): =COLUMN(INDIRECT(B2&"1"))