Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy text hyperlinks and paste them as source addresses?
I have 1000s of text hyperlinks in a spreadhseet (are these called target
links?) and I want to display them as proper addresses (called source?) You can see the URL address in the yellow text box that appears when I hover over the link. Have been unable to find anything in paste special, or in the View tab in Options to help. Know that there is a Visual Basic way but can't use it! Help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy text hyperlinks and paste them as source addresses?
This one line UDF:
Function hyp2(r As Range) As String hyp2 = r.Hyperlinks(1).Address End Function will return the address part of the hyperlink. So if A1 contains the hyperlink, then =hyp2r(A1) will return the address (URL) -- Gary's Student "Minuette" wrote: I have 1000s of text hyperlinks in a spreadhseet (are these called target links?) and I want to display them as proper addresses (called source?) You can see the URL address in the yellow text box that appears when I hover over the link. Have been unable to find anything in paste special, or in the View tab in Options to help. Know that there is a Visual Basic way but can't use it! Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
hyperlink copy / paste | Excel Discussion (Misc queries) | |||
Copy and paste | Excel Discussion (Misc queries) | |||
Copy & paste from Word to Excel with hyperlinks | Excel Discussion (Misc queries) | |||
Random hyperlinks everywhere! | Excel Discussion (Misc queries) |