Using Paste Special - Values with the HYPERLINK function in Excel
- by Pete
I have a long list of data in Excel. 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.
So i do Paste Special -- Values
Which does the job but then the link is removed. How can i paste the values and keep the hyperlink?