I am looking for a formula I can use in any cell that will return the column LETTER of the column the formula is in,
I can get the LETTER and ROW number using the below, but I cant get it without the ROW information
=ADDRESS(CELL("row"),CELL("col"))
I don't mind using vba to work it out if there isn't a formula that can achieve this.
NOT A DUPLICATE OF How to get the current column name in Excel? I only want the COLUMN and not the line number !