retrieve hypertext link to new cell

With
A1: containing a hyperlink.....eg http://www.google.com/ (displayed as: Google)

• ALT+F11.....to open the Visual Basic Editor

• Right-click on your workbook name in the VBA Project panel
...Insert: Module

• Copy the below VBA code and paste it into that module:

Function GetHlinkAddr(rngHlinkCell As Range)
Dim sFormula As String

With rngHlinkCell
    If .Hyperlinks.Count Then
       GetHlinkAddr = .Hyperlinks(1).Address
        
    ElseIf .HasFormula Then
        sFormula = .Formula
        If InStr(1, sFormula, "HYPERLINK") > 0 Then
            GetHlinkAddr = Split(sFormula, Chr(34))(1)
        Else
            GetHlinkAddr = "No Hyperlink"
        End If
    End If

End With

End Function

Using that function in your workbook...
This formula returns the URL referenced by that hyperlink:

B1: =gethlinkaddress(A1)

In the above example, the formula returns: http://www.google.com/

Note: XL2007 and later
When you save that workbook, you'll need to save it as a Macro Enabled (.xlsm) workbook.

Is that something you can work with?

On-Line Excel does not support VBA at this time.
You'd need to use an off-line Excel file.