View Single Post
  #5  
Old September 22nd, 2003, 03:44 PM
Chuck Buker
external usenet poster
 
Posts: n/a
Default 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)


.