I have a large table (over 600 entries) of hyperlinks.
They are all in a single column.
They are all of the form: =HYPERLINK("http://www.something.com","something")
I need to convert the table into a table of hyperlinks without function
calls. The result table would look like it was made by using
Insert=Hyperlink...

I have tried various copy/paste specials and they all failed.

I am not much of a programmer, but I can copy and paste into the VBA editor.
Thank you in advance for any guidance you give me.
--
jake