Consider the following:
I wish to remove columns B & C after I have created the hyperlinks using the formulae, but then I get #REF! reference errors because the formulae rely on the data in those columns.
I tried copying column A and then using Paste Special > Paste Values Only but it didn't replace the cell references by their values. Nor did any other Paste Special option work any better.
Is there any way to copy the hyperlinks with the cell references replaced by their values?