Get the current cells column letter

A formula to return the column letter(s) when placed in any cell.

For instance if the formula was put in cell G56 the result in cell G56 would be G. If it was put in IMB213 then the result would be IMB.


=LEFT(SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$",""),LEN(SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$",""))-LEN(ROW()))






Contact us for some advice and guidance on how your Excel development could be created and start helping your business straight away. Contact Us

Datanology

Leave a Reply

Your email address will not be published. Required fields are marked *