Archive of Mr Excel Message Board

Back to Hyperlinks in Excel archive index
Back to archive home

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

Re: Retrieve Hyperlink Data

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.