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

Windows Software
Comments are closed
, , , , ,

Written by

Blackmore Computer Services, owned and operated by Kyle Blackmore, is here to help you. Serving the Bozeman and Belgrade area for 7+ years.

View all posts by:

Related Posts

Comments are closed.