I need to return a text string path for the current file, but one folder up.
I have found: =LEFT(CELL("filename",P1),FIND("[",CELL("filename",P1))-1)
and even =HYPERLINK("..","Open One Folder Up")
The first one will return the Path in text for the current file folder, and the second one is a hyper link. How can I get the Path for the Hyperlink to show?
Thank you!!
I have found: =LEFT(CELL("filename",P1),FIND("[",CELL("filename",P1))-1)
and even =HYPERLINK("..","Open One Folder Up")
The first one will return the Path in text for the current file folder, and the second one is a hyper link. How can I get the Path for the Hyperlink to show?
Thank you!!