Capturing text string from a hot link

[pbhogal]

Hello

Suppose I have a hot link(s) in an excel spreadsheet. In adjacent cells to these cells containing hot link, I want to put the hot link's URL as text.

Can this be done in excel?

Thanks.

 

[Scott Huish]

I'm assuming you mean a hyperlink?

=TEXT(A1,"@")

 

[pbhogal]

Yes and many thanks for the help!

I'm assuming you mean a hyperlink?

=TEXT(A1,"@")