software

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
--
Eli Kedar
Israel


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

=HYPERLINK(F5amp;G5)

Regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=521671Dav
I will try it

Thank you
--
Eli Kedar
Israelquot;Davquot; wrote:

gt;
gt; If your directory path is in F5 and your filename is in G5 something
gt; like the following should work
gt;
gt; =HYPERLINK(F5amp;G5)
gt;
gt; Regards
gt;
gt; Dav
gt;
gt;
gt; --
gt; Dav
gt; ------------------------------------------------------------------------
gt; Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
gt; View this thread: www.excelforum.com/showthread...hreadid=521671
gt;
gt;