Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to Display hyperlink addresses that already exist as links to
How do you do this? Is there a formula? We have a document with 3800 rows
of data. Two of the cells have text in them that link to URLs - we now need to display the full link address in those cells rather than the text for a conversion that we're donig. Is there an easier way other than getting the link properties for each and every hyperlink? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to Display hyperlink addresses that already exist as links to
Enter this tiny UDF:
Function hyp2(r As Range) As String hyp2 = r.Hyperlinks(1).Address End Function If A1 contains a hyperlink then =hyp2(A1) will return the URL (address part) -- Gary's Student "Michelle" wrote: How do you do this? Is there a formula? We have a document with 3800 rows of data. Two of the cells have text in them that link to URLs - we now need to display the full link address in those cells rather than the text for a conversion that we're donig. Is there an easier way other than getting the link properties for each and every hyperlink? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink display text maximum in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I display hyperlink in Excel cell? | Excel Discussion (Misc queries) | |||
how do I display a hyperlink in a seperate cell in excel? | Excel Discussion (Misc queries) | |||
Graphic display of links | Links and Linking in Excel | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |