Hyper link to file location

[BrachChad]

How do I write a formula to insert a hyperlink to the folder that the file is in, and still show the full path name?

 

[BrachChad]

I am also having trouble with a formula to show the full path and file name.

=cell("filename") returns the file path correctly but returns the file name like this:

[quote45676.xlsm]quote

I need to just be quote45676???

Any ideas would be greatly appreciated.

Thx
Chad