How to read hyperlink text from excel cell




Would anyone know how to extract the actual link from a hyperlink in Excel?
When copying the data to a datatable, only the direct cell text is copied instead of the link itself.



@Daniel_M Can you elaborate more to understand


Hi Indra,

I have an Excel file containing hyperlinks with a different display name as to the actual link itself.
My problem is that I find no way to read the actual links from the cells containing a hyperlink.

Thank you in advance