I currently have a spreadsheet with multiple sheets, and LOTS of hyperlinks.
Right now the hyperlink opens a file, and all of that works fine. I would
like to create in the far right column a second hyperlink that opens the
folder the file is located in.

So, somehow using a formula or VBA I would like to take all of the path
except the file name and create a hyperlink without having to make each
hyperlink manually.

For example I may have a hyperlink of with text of joe and it points to
\\servername\Sharename\Folder1\Folder2\Folderx\pho tograph.jpg

The path from hyperlink to hyperlink will be different, i.e. different
folders. I just want to peal everything off except the filename.