Find Column Letter
=CHOOSE(INT((COLUMN()-1)/26)+1,"","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z")&IF(MOD(COLUMN(),26)=0,"Z",CHOOSE(MOD(COLUMN(),26),"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y"))
This is one of my "crazier" formulas. Anyone know an easier way?
Here is a way. Alan M. Robertson showed me this alternative.
=CONCATENATE(IF(COLUMN()>26,CHAR(64+INT((COLUMN())/26)),""),CHAR(65+MOD((COLUMN()-1),26))))
And good grief, I actually ended up writing a short formula for a change (lucky me)
=MID(ADDRESS(ROW(),COLUMN()),2,FIND("$",ADDRESS(ROW(),COLUMN()),2)-2)
Here's yet another alternative. Change A1 to suit the cell where you enter
and drag to suit. Thanks to Duane K. Sonsteng (formula from Dave Peterson?)
=SUBSTITUTE(SUBSTITUTE(CELL("address",A1),"$",""),ROW(),"")