I have a long list of data in Excel 2007. Using the Hyperlink function:
=HYPERLINK(C2,A2)
I've added individual links to them all. Now I want to get rid of the function and just leave the data with the link.
If I do Paste Special > Values, it does the job but the link will be removed.
How can I paste the values and keep the hyperlink?
Best Answer
How about a paste out to Word? (and then copy it there and paste back into Excel if you really need it back in Excel).
This retains both the link and the title, and is clickable.
No paste special required, although depending on your settings you may get some naff formatting inherited from the the default tabel format in Word. You can get round this using the paste options in Word to keep the source formatting.