Feb 10 2023 06:24 AM
It used to be possible to insert a formula into an Excel workbook which would show the file name and path. Can anyone remember what the formula was is it still valid as I can't find it in the formulas tab?
Feb 10 2023 06:34 AM
@KenTreanor
=CELL("filename") returns path+filename+sheetname
To remove the sheet name:
=SUBSTITUTE(LEFT(CELL("filename"),FIND("]",CELL("filename"))-1),"[","")
Warning: this won't work if the path/filename contains [ or ].
