View original (French)

Get letter from Excel column address

Danielitoo5 Posted messages 4 Status Member -  
Patrice33740 Posted messages 8400 Registration date   Status Member 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 answer

  1.
    Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 785
     
    Hello,

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

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

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