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"))


 


Comments

Post a Comment

Popular posts from this blog

Create Application specific password for Google

Create Application specific password for Google Starting 2022-05-30 Google is no longer supporting less secure apps. Please use below steps to turn on App password for your google account. Login to your Google email at https://gmail.google.com . Navigate to https://myaccount.google.com/signinoptions/two-step-verification . Enable " two step verification ". Create application-specific password via https://security.google.com/settings/security/apppasswords . Save a 16 digits App password that can be used by specific app using your Google email address.      
Read more