Convert Hyperlink into URL
 

hey guys... I have a long single-column sheet of urls which are displayed as
€œfriendly_name€� hyperlinks (blue & underlined)€¦ what I need are the
€œlink_location€� url addresses instead€¦ I tried €œcopy€� then €œpaste special€�
but no luck€¦ and the command €œremove hyperlink€� simply converts the hyperlink
into text and loses the url all together€¦ any ideas? Thanks!

Convert Hyperlink into URL
 

Try this tiny UDF:

Function hyp2(r As Range) As String
hyp2 = r.Hyperlinks(1).Address
End Function


--
Gary's Student


"HarryNYC" wrote:

hey guys... I have a long single-column sheet of urls which are displayed as
€œfriendly_name€� hyperlinks (blue & underlined)€¦ what I need are the
€œlink_location€� url addresses instead€¦ I tried €œcopy€� then €œpaste special€�
but no luck€¦ and the command €œremove hyperlink€� simply converts the hyperlink
into text and loses the url all together€¦ any ideas? Thanks!

Convert Hyperlink into URL
 

well, after figuring out what a UDF was and how to create one, the damn
thing worked... you rock... thanks man!


"Gary''s Student" wrote:

Try this tiny UDF:

Function hyp2(r As Range) As String
hyp2 = r.Hyperlinks(1).Address
End Function


--
Gary's Student


"HarryNYC" wrote:

hey guys... I have a long single-column sheet of urls which are displayed as
€œfriendly_name€� hyperlinks (blue & underlined)€¦ what I need are the
€œlink_location€� url addresses instead€¦ I tried €œcopy€� then €œpaste special€�
but no luck€¦ and the command €œremove hyperlink€� simply converts the hyperlink
into text and loses the url all together€¦ any ideas? Thanks!

Convert Hyperlink into URL
 

You are very welcome.
--
Gary''s Student


"HarryNYC" wrote:


well, after figuring out what a UDF was and how to create one, the damn
thing worked... you rock... thanks man!


"Gary''s Student" wrote:

Try this tiny UDF:

Function hyp2(r As Range) As String
hyp2 = r.Hyperlinks(1).Address
End Function


--
Gary's Student


"HarryNYC" wrote:

hey guys... I have a long single-column sheet of urls which are displayed as
€œfriendly_name€� hyperlinks (blue & underlined)€¦ what I need are the
€œlink_location€� url addresses instead€¦ I tried €œcopy€� then €œpaste special€�
but no luck€¦ and the command €œremove hyperlink€� simply converts the hyperlink
into text and loses the url all together€¦ any ideas? Thanks!