How to convert a column index to a column name?

[Gaffer]

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.

[mariosv]

Maybe a formula like this, is what you want:

=MID(ADDRESS(1;index);2;LEN(ADDRESS(1;index))-FIND("$";ADDRESS(1;index);1)-2)

[JohnSUN]

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))

[JohnSUN]

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

[mariosv]

Right @JohnSUN, the simplest the better.