Paste Special Column of Hyperlink Formulas

[danrofohio]

I have a spreadsheet where the basic function is to merge information from two worksheets. One sheet has a column hyperlinks (to external web pages) and a unique date for each row. The other sheet has descriptive information, tags, etc. I now have all the data merged, sorted, and formatted the way I want on a third sheet. Now, I want to eliminate the first two sheets, because I don't need them, and I want to save the third sheet as a one-tab, html file.

Normally, I would just copy all of the cells on the third sheet and paste them to the same location using paste special - values and formats or just values. However, when I do that, I lose all the hyperlinks. One column looks like this:

=HYPERLINK(VLOOKUP(A3,StudyLinkTable,4,FALSE))
​

I need to get rid of the formulas while still retaining the functionality of hyperlink. If I copy and paste special (values) it still looks like a hyper link with the correct URL, but the hyperlinks to the web pages don't work any more.

How can I either:

A.) Copy/paste the values while retaining the hyperlink functionality, or

B.) Convert the values to hyperlinks again?

Thanks,
Dan R.

 

[reberryjr]

Try this link:
https://superuser.com/questions/580387/how-to-turn-plain-text-links-into-hyperlinks-in-excel