[Isaac Harned]

Like Doug says above, there is the hyperlink function, you can place a formula in lets say column P (depends on how long your addresses are, whatever column gets it out of the way) that creates a shortened hyperlink for the addresses pasted in column A. You can then either hide cells, hide tab or copy and re-paste the links. This would be the simplest way, but there are also ways to create a PDF index based on your files as well.

The simple process would look like this, multi-select files and “Copy Full Pathnames” as shown in screenshot below. Then open Excel workbook and paste into desired column.

For the following formula to work, it assumes that there is a separator between the sheet number and name ” – “. It will look for this separator and shorten the link to only display the sheet number. If there is no data, there will be no result shown:

=IFERROR(HYPERLINK(A1,LEFT(RIGHT(A1,LEN(A1)-FIND(“*”,SUBSTITUTE(A1,”\”,”*”,LEN(A1)-LEN(SUBSTITUTE(A1,”\”,””))))),FIND(” – “,RIGHT(A1,LEN(A1)-FIND(“*”,SUBSTITUTE(A1,”\”,”*”,LEN(A1)-LEN(SUBSTITUTE(A1,”\”,””))))))-1)),””)

grabbingFullPAth.png 63 KB Image File - Click to view

Options

• Copy Download Link