8. Excel Tips - Get file path with an excel formula
This is a quirky one.
You can use the excel function call CELL("filename") to retrieve something that should be the file name, but for some odd reason isn't.
Fortunately, the function call does have a couple of uses - You can use it to retrieve the file path by using a few text functions around it like so: =LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)
- returns file path (if you have saved the file).
Try it and see !
Also take a look at how to permanently show the file path on the toolbar:
Training Video on getting the file path: