Convert a Cell Reference to Text
Thanks very much. Both will do the job.
Now my next question ... since I sent that post last
night and stupidly included my email address, I have
received more than 30 junk emails, all of which contained
various worms and viruses. Is this common, will it
dissipate, or will I have to get a spam filter or change
my email address to make it stop?
Chuck
-----Original Message-----
"Vasant Nanavati" wrote...
In cell A2, instead of:
A100
use:
=ADDRESS(ROW(A100),COLUMN(A100))
....
Or =CELL("Address",A100)
.
|