View original (French)

Get letter from Excel column address

Danielitoo5 Posted messages 4 Status Membre -  
Patrice33740 Posted messages 8400 Registration date   Status Membre Last intervention   -
Hello,
I need an Excel formula that returns the letter representing the corresponding Excel column address.

Thank you!

Configuration: Windows 7 / Firefox 45.0

1 réponse

Réponse 1 / 1
Patrice33740 Posted messages 8400 Registration date   Status Membre Last intervention   1 781
 
Hello,

For a cell called MyCell: 
=MID(LEFT(CELL("address",MyCell),FIND("$",CELL("address",MyCell),2)-1),2,3)

--
Best regards
Patrice
5
Danielitoo5 Posted messages 4 Status Membre
 
Thank you for the promptness of your response. I am still waiting for other, simpler answers than yours.
0
Patrice33740 Posted messages 8400 Registration date   Status Membre Last intervention   1 781
 
Re,

It is difficult to make it simpler knowing that the column letters go from A to XFD.
0