Hello.
I'm using excel as browser for files in multiple location.
I have thousands links like this:
B5: =HYPERLINK("C:\Specific\Folder\" & A5 &".docx"; A5)
Where A5: 001-002-003
Then B5 links to a file called: 001-002-003.docx in specific folder.
In my sheet I'll hand in, I'm not allowed to have the A5 with the filename.
What colleges do is manual select all the hyperlinks.
As I need to remove the A5 I though I could copy/paste the B column with all the hyperlinks with some special effect to keep the link without referencing to filename in A5.
Any other way around this?
Bookmarks