Trying to create a link to file from cells that contain the addresses texts
Example:
Cell A1 = D:\
Cell A2 = My Documents\
Cell A3, Filename = Textfile.txt
The required link is D:\My Documents\Textfile.txt as if I did it from Insert Link
I have a huge list of links to various files in the server and I want to re-arrange files in new folders and I want to modify the old addresses list to the new locations.