How to pull all hyperlinks from a column?

Question

excel

I have a column with N number of cells.
Each cell of the column contains a hyperlink of the form:
DOWNLOAD
Accordingly, the links are different in each cell.

How to get all these links in a list?

Answer 1

VBA source
Here's a VBA solution for those who can use it.
Create a VBA module with the following code:

Public Function GetURL(c As Range) As String
    On Error Resume Next
    GetURL = c.Hyperlinks(1).Address
End Function

To use, enter the following into any cell:
=GetURL(A1)
where A1 contains a hyperlink.
The function at work: