View original (French)

Excel: letter back from COLUMN()

Solved
Greg -  
 olivier -
Hello,

I need to use the COLUMN() function in an Excel formula. Unfortunately, this function returns a number instead of letter(s). Does anyone know how to convert this number back into letter(s)?

2 answers

  1.
    mic13710 Posted messages 1165 Registration date   Status Member Last intervention   360
     
    =LEFT(ADDRESS(1,COLUMN(),4),LEN(ADDRESS(1,COLUMN(),4))-1)
    Formula retrieved from this site:
    http://www.excelabo.net/trucs/lettre_colonne
    --
    Michel
    28
    1. Greg
       
      Thank you!
      0
    2. fflintt
       
      Thank you mic13710, you can't imagine how long I've been looking for this formula that is so useful and precise!
      0
    3. mic13710 Posted messages 1165 Registration date   Status Member Last intervention   360
       
      No problem, especially since I didn't have much to do with it. Just a simple copy/paste from the link in my message to the excellent Excelabo site.
      0
    4. Rony63 Posted messages 1 Status Member
       
      Thank you, it gave me the idea to use this formula which is shorter and therefore less resource-intensive: =SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")
      0
    5. olivier
       
      Very useful, thank you!
      0