Sorry for the slew of questions.
I have hyperlinks in a spreadsheet. However, I'd like for a cell to equal it's hyperlink address. For example, in A1 I have CCNC 2005- Consumer Commmunications & Networking with the hyperlink address as http://www.comsoc.org/confs/index/html. I can't see this in the formula bar. I can only see it through the Edit Hyperlink menu option. I want D1 to equal http://www.comsoc.org/confs/index/html and have every cell in D to follow through. Any ideas?