Function to Return a Cells Column Letter

[rdsmit1]

Is there a function you can type into a cell and it will return that cells column letter?

 

[Jonmo1]

You can use
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),1,"")

But there is really no need to convert column number to letter (other than visual purposes)
You can create formulas that refer to column numbers instead of letters.

 

[_Andrew_]

You can use<br>
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),1,"")<br>
<br>
But there is really no need to convert column number to letter (other than visual purposes)<br>
You can create formulas that refer to column numbers instead of letters.

<br>
<br>
Actually, it is not just for aesthetics/visual purposes. This can be necessary to avoid #REF! errors when using more advanced formulas involving INDIRECT (there can be other applications for it also). <br>
<br>
For example, in the formula: <br>
=INDIRECT(COLUMN()&"3") <br>
<br>
one would like the column text reference returned. e.g. let's say we are referring to column 6. The above would evaluate to =INDIRECT(63) yielding the #REF! error unless you convert it to the letter column reference.<br>
<br>

 

[pgc01]

HI Andrew

BTW, another option:

=INDEX($3:$3,COLUMN())

 

[Jonmo1]

Also

=INDIRECT(ADDRESS(3,COLUMN()))