How to extract the column letter

[DashboardNovice]

Using something like column(D1) will return 4. But is there a function which can return the letter "D" instead of the column number?

 

[Somendra Misra]

Hi Dashboard,

I don't know if there is a direct function to return it like that, but below custom formula can do it. Try this:

=MID(CELL("address",A1),FIND("$",CELL("address",A1))+1,FIND(" ",SUBSTITUTE(CELL("address",A1),"$"," ",2))-FIND("$",CELL("address",A1))-1)

Regards,

 

[Hui]

For the current column
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")

or
For an address in E1
=SUBSTITUTE(ADDRESS(1,COLUMN(E1),4),"1","")