Converting column number to name?

Posted by Mike Fleuette on September 25, 2001 12:10 PM

The COLUMN() function returns a number corresponding to a particular column; is there an easy way to convert this number to a column name? E.g., if COLUMN(AA1) = 27, is there an easy way to convert 27 to "AA"?

Posted by IML on September 25, 2001 12:19 PM

You could use
=LEFT(ADDRESS(1,COLUMN(AA1),2),1+(COLUMN(AA1)>26))
for aa1.

good luck

Posted by Mike Fleuette on September 25, 2001 12:55 PM

Thanks for the quick response!