How can I build link to file by concatenating texts in cells?

0

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.

Answer
Discuss

Answers

1

Create the hyperlink using this formula:-

=HYPERLINK(A6&A7&A8,"Test")
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login