take this:

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

put his on cell a1, copy it to anywhere and it will work accordingly.

no fuss no mess
--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Eric" wrote:

Does anyone have any suggestions on how to display the column name?
For example, under column AB, I would like to display "AB" in cell AB1
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric