I have a column of hyperlinks in an excel file.
I've used formula: "=HYPERLINK(A2,A2)" and it gives me a hyperlink to a file on drive.
In column A there are text versions of alll of the links - source filepaths, I want that column to now have the live links. So I try to copy the hyperlink column over - this does not work.
In the formula bar it shows as the formula, not the link and I want to paste these links over the A2 so the A column has the link.
Any advice without using macros would be greatly appreciated