Here is yet another way...

=IF(A126,CHAR(64+INT(A1/26)),"")&CHAR(65+MOD(A1-1,26))

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
I doubt if anyone would call this more elegant... hell, it probably isn't
even as efficient... just different.

=REPLACE(ADDRESS(1,A1,2),FIND("$",ADDRESS(1,A1,2)) ,9,"")

--
Rick (MVP - Excel)


"Brotherharry" wrote in message
...
in A1

=column(D2)

would return the number 5. I want the reverse of that.

e.g.a function that would when pointed at A1, returns the text "D"

This beast does the job, but is there are more elegant way?

=LEFT((ADDRESS(1,A1,2)),((FIND("$",(ADDRESS(1,A1,2 ))))-1))