Hi Tom,

=Substitute(CELL("address"),"$","")
would always return A1


Not always A1 :-) - it depends in which cell you confirm the formula, but
you are right having the same result in all cells is not correct. This one
should work:

=SUBSTITUTE(CELL("address",A1),"$","")

and another one although a bit more expensive:
=SUBSTITUTE(CELL("address",INDIRECT("rc",0)),"$"," ")

CHAR(64+CELL("col",A1)))&CELL("row", A1)
would always return A1

this one seems to work fine for me :-).

Regards,
KL