Tip Printed from ExcelTip.com
How to change column number with letter in Microsoft Excel



Column number in cell A1: 5
 
The Function:            

=IF(AND(A1>0,A1<257),IF(A1>26,CHAR(64+INT((A1-1)/26)),"")&CHAR(65+MOD(A1-1,26)),"")        


Result:                   E