I have a series of cells that are hyperlinked. The copy displaying in the
cells is not the hyperlink, but other text. How can I copy the value of the
hyperlink to another cell? Again, I do not want the text that is displaying
in the cell, but the hyperlink to appear when I paste to a new cell.

Is there a formula or function that will allow this?