Hello,

I have a pretty simple need to take a hypertext link and copy the URL
as text in the next field over. The links have a name "click here for
details" that cover up the url and I am having problems extracting it.
The urls are pulled from a web query. I would like to be able to
this through a macro or a function call.

In addition, I need to pull out data in the middle of the get string
and put in the adjacent cell as well.

Can anyone recommend how best to accoplsih this or point me in in a
certain direction?



Thank you!