Excel function to do exactly the opposite of =HYPERLINK()
Posted on 2016-08-09
Does Excel have a function which is exactly the opposite of =HYPERLINK()?
For example, using the =HYPERLINK() function, a long list of URLs in an Excel column can easily be converted to a corresponding list of hyperlinks in a different column.
I'm wondering if there is a function which, beginning with a long list of hyperlinks, will produce a corresponding list of URLs.
If not, what is the best workaround?