Extracting Url from a hyperlink

C

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?
 
F

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
 
G

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
 
Top