I have a cell that has a hyperlink added to it via CTRL-K.

Is there a way for the hyperlink function to grab that info? As opposed
to having a path stored in a cell, I have a "friendly name" in there
with ctrl-k'd hyperlinks. I know how to use hyperlink if my target cell
contains a path name in clear text, just not the other way.

Hope I'm clear.