| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Hyperlink to cell value automatically | Excel Worksheet Functions | |||
| Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
| How to convert a hyperlink to its target full-text URL | Excel Discussion (Misc queries) | |||
| Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
