Convert a Cell Reference to Text
Hi Chuck:
Welcome to the club! This is a new but unfortunate phenomenon. Many of us
here have been getting inundated with virus-containing emails since last
week. Some of us are getting 200-300 a day. I'm hoping that this will
dissipate soon as I would hate to change my email address. One of the MVPs
has reported good results using SpamAssassin; I have no experience with it
personally.
Good luck!
Regards,
Vasant.
"Chuck Buker" wrote in message
...
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)
.
|