Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

Return a worksheet column letter (ranging from A to XFD) for the value contained in cell A1

Input the formula: =LEFT(ADDRESS(1,A1,4),FIND(1,ADDRESS(1,A1,4))-1)