Extracting Url from a hyperlink

[Carlton Noles]

I have a large list of hyperlinks I have imported to
Excel. I need to get the urls these links point to. Is
there a way to do this through code or an Excel function?

 

[Frank Kabel]

Hi
you may provide some examples of your data. And also if there's some
logic to identify the start and end of your URL

 

[Guest]

What is shown in column A is My biz (blue and underlined)
and in column B i am manually extracting
http://www.mybiz.com as text. in other words column a has
the hyperling showing the name or title of the site and i
am trying to build a list of urls in text. Was that
helpful.

Regards
-c

 

[Frank Kabel]

Hi
Tom has posted a solution for this. You may also take a look at:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm