Retrieve Hyperlink Data

Posted by Dave Gordon on January 09, 2002 3:25 AM

I have copied data from a web page into a worksheet and would like to place the actual link name value into a seperate cell (i.e. http:\\www.mrexcel.com ..)on the same worksheet. Can anybody help

Posted by Chris D on January 09, 2002 5:53 AM

on mine (Excel 97, Windows ME) if you right click the web address in your browser and select "copy" you can then just paste special and text into the worksheet

it shows it as text : "14029.html"

Hope this helps
Chris