Excel: letter back from COLUMN()
Solved
Greg
-
olivier -
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)?
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 réponses
=LEFT(ADDRESS(1,COLUMN(),4),LEN(ADDRESS(1,COLUMN(),4))-1)
Formula retrieved from this site:
http://www.excelabo.net/trucs/lettre_colonne
--
Michel
Formula retrieved from this site:
http://www.excelabo.net/trucs/lettre_colonne
--
Michel
Greg
Thank you!
fflintt
Thank you mic13710, you can't imagine how long I've been looking for this formula that is so useful and precise!
mic13710
Posted messages
1165
Registration date
Status
Membre
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.
Rony63
Posted messages
1
Status
Membre
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","")
olivier
Very useful, thank you!