View original (French)

Excel - letter corresponding to a column

Solved
Tamarin Posted messages 135 Status Member -  
Tamarin Posted messages 135 Status Member -
Hello,

I have several Excel sheets in my file and in a summary sheet, I am using the INDIRECT option...

I need to find a function that allows me to obtain the letter(s) corresponding to the column of a given cell.

I use the ROW function to get the row number, but the COLUMN function returns a column number, whereas I want the letter(s)

Do you have any idea?

Thanks in advance

Configuration: Windows XP / Firefox 10.0.2

3 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    if you use up to column Z max:
    =CHAR(A2+64)

    if beyond column Z (26):
    =LEFT(ADDRESS(1,A2,4),LEN(ADDRESS(1,A2,4))-1)

    eric
    1