# How to convert a column index to a column name? [closed]

This seems such an obvious question but my Google skills are letting me down.

How do I convert a column index to a column name? I want a function where I supply zero and it returns the string "A". Two would give me "C". 26 would give me "AA" etc.

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-20 19:07:07.820808

Sort by » oldest newest most voted

Maybe a formula like this, is what you want:

=MID(ADDRESS(1;index);2;LEN(ADDRESS(1;index))-FIND("$";ADDRESS(1;index);1)-2) more ## Comments May be not "index", but "index-1" (if 0=A;2=C;26=AA...)? My variant of the formula is more cumbersome =TRIM(LEFT(SUBSTITUTE(CELL("ADDRESS";OFFSET(A1;0;index)) ;"$";" ");7))

( 2013-01-23 14:18:52 +0200 )edit
1

Oh! I remembered the another variant of the decision! =SUBSTITUTE(ADDRESS(1;index+1;4);"1";"")

( 2013-01-23 14:42:09 +0200 )edit

Right @JohnSUN, the simplest the better.

( 2013-01-23 22:24:27 +0200 )edit