Return filepath/name only to a cell

Hello, I'm trying to return the active path and filename in a cell: C:\Foldername\Filename.xlsm ..

If I use formula: =cell('filename"), it returns C:\Foldername[Filename.xlsm]SheetName

I don't want the sheetname, nor the filename in brackets, so I found the following formula that replaces the brackets, but it gets rid of both the filename and sheetname, leaving only the path: =LEFT(K1,FIND("|",SUBSTITUTE(K1,"\","|",LEN(K1)-LEN(SUBSTITUTE(K1,"\","")))))

I was able to go into Options and add filepath to the quick access bar.. If there is a way to reference it in a cell, that would work as well.

Any ideas? Thanks!

=SUBSTITUTE( LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))-1),"[","")

this will return what you want/need

Here is what is returned
C:\Users\025\Desktop\[sampleconditions.xlsx]Dashboard Your formula
C:\Users\025\Desktop\sampleconditions.xlsx New Formula

Perfect! Thanks so much!