I have a spreadsheet with a large number of cells containing hyperlinks with display text different than the hyperlink location
ie:
cell location: A1
display text = "Site Info"
hyperlink location = "http://www.mylocation.com"
Is there an excel formula that allows me to access the text string of the hyperlink location?
Ideally it would look like this:
FORMULA(A1) = "http://www.mylocation.com"
Best Answer
I only needed to extract the address from a single cell's value so I found this small function handy:
http://excel.tips.net/T003281_Extracting_URLs_from_Hyperlinks.html