Tag Archives: get column letters

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()))

the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group