Copy only hyperlink to a new cell

M

Mike_Gormley

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top