Column Labels

[stiles]

Anyone know what formula i can use to obtain just the
letter part of the column label into a cell? For example,
what formula would i write, if i was in cell AB13 to get
the result "AB" in the cell?

Thanks.

 

[J.E. McGimpsey]

One way:

=LEFT(SUBSTITUTE(CELL("address",AB13),"$",""),(COLUMN()>26)+1)