Excel – How to return the column letter of cell reference

Here is an excel formula to return the  column letter of the refereed cell; this one extends to AA, AB ......---> to end:

=LOWER(SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")) - small letters

or

=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","") - caps

Comments are closed.