Refer to Hyperlink
How can I refer to the hyperlink information of a cell?
Lets say cell A1 contains text "website"
but the hyperlink refers to "http://www.website.com"
I would like for cell B1 to only show the hyperlink information of
cell A1
Any help will be appreciate
TIA
|