View Single Post
  #6  
Old September 22nd, 2003, 04:42 PM
Vasant Nanavati
external usenet poster
 
Posts: n/a
Default 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)


.