I have a spreadsheet with a large number of cells containing hyperlinks with display text different than the hyperlink location
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"