Hi Niranjan
If they were created via the HYPERLINK Function within Excel you maybe able to use the samee function to 'reverse it, so to speak.
To cover bases though, this should get them from column A into Column C
Sub GetAddress()
Dim rCells As Range
On Error Resume Next
For Each rCells In Range("C1", Range("A65536").End _
(xlUp).Offset(0, 2))
rCells = rCells.Offset(0, -2).Hyperlinks(1).Address
Next
On Error GoTo 0
End Sub