Covert text to Hyperlink

E

Eli Kedar

I have a large worksheet, one column contains the Folder Path, the other
column contains the file names.

How I can make a Hyperlink in a third column from the above data.

Thanks in advance
 
D

Dav

If your directory path is in F5 and your filename is in G5 something
like the following should work

=HYPERLINK(F5&G5)

Regards

Dav
 
Top