Extracting Hyperlink

[charles]

How do I display the hyperlink address instead of the text
information. Is there a function that would allow me to
extract the hyperlink and put in cell?

 

[Frank Kabel]

Hi
see: http://www.mvps.org/dmcritchie/excel/buildtoc.htm

look for 'HyperlinkAddress' in the middle of this page