Display Hyperlink without VBA or Macros

Question

I'm familiar with the HYPERLINK formula in Excel and I'm trying to find the inverse without having to run macros or VBA.  I have regular Excel sheets that come with a column of links entitled "Photo."  I'm looking for formula solution (if possible) to extract the link address that is hyperlinked to the word "Photo."  The word "Photo" is in thousands of lines of data and each is a unique web address.        thank you

Answer 1

I don't think that it is possible without VBA. You could use the following user-defined function:

Function LinkAddress(c As Range) As String

    If c.Hyperlinks.Count Then

        LinkAddress = c.Hyperlinks(1).Address

    End If

End Function

Let's say you have hyperlinks in B2 and down. In (for example) C2, enter the formula

=LinkAddress(B2)

and fill down as far as you want.