Ms Excel Column Name to 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"))