Get Sheet Name or File Name or File Path

If you want to get some data use the following

 

=CELL("filename")

 

Then you can use ‘find’ function to trim and get what ever informaiton you want to extract