Hyperlinking to documents in Excel

[DJCox]

I have extracted a tab delimited .txt list of all the documents on ou
server at work. I would like to import this list into an Exce
Spreadsheet (easy enough) and then hyperlink back to the documents o
the server. Is there a way to hyperlink automatically? I have severa
thousand documents and hyperlinking one at a time is not ver
realistic. I have the option of pulling the list with either th
relative path (just the document name and extension) or with th
absolute file path (give the complete path of every document). I
anyone has any suggestions I'm all ears. Thank you.

Dale Co

 

[Kieran]

DJCox

The =hyperlink() function will allow this.
Create a column that contains the full path and file name and us
something like =HYPERLINK(A2,A2). or =HYPERLINK(A2&B2,A2&B2) where th
path and file name are in separate columns.

Note the file name and path need to be separated by a '\' if ther
isnot one already appended to the path

 

[DJCox]

Thank you so much for your help. It worked and you saved me a LOT o
time. Thanks again