I am using Excel 2016
I have a set of data in column A, In column B (cell B3) I have this formula for a hyperlink: =HYPERLINK("ebms:inventry?"&A3, A3).
I want to delete column A now, but since it is being referenced in the formula in column B, I need to copy and paste column B as values.
Doing so will remove my hyperlinks.
Is there any way to paste as values but keep the hyperlink intact? This has frustrated me for a long time and just googling it I'm not finding anyone else who has this problem.
Bookmarks