It's interesting why obvious solutions don't come up sometimes!
Stefi
ΓΙΑΝΝΗΣ Χ.Β. ezt *rta:
if column =AA?
so better
=LEFT(ADDRESS(1,COLUMN(),4),IF(COLUMN()<27,1,2))
-------
Ioannis, Athens
"cKBoy" wrote:
Can column() return a letter instead of a number? I am planning to use
it with INDIRECT? Is that possible?
=INDIRECT(row() & column())?
--
cKBoy
------------------------------------------------------------------------
cKBoy's Profile: http://www.excelforum.com/member.php...o&userid=31522
View this thread: http://www.excelforum.com/showthread...hreadid=512119