View original (French)

Excel - letter corresponding to a column

Solved
Tamarin Posted messages 135 Status Membre -  
Tamarin Posted messages 135 Status Membre -
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 réponses

Réponse 1 / 3
eriiic Posted messages 24581 Registration date   Status Contributeur 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