A formula to insert the filename of the workbook in a cell:
=MID(CELL(”filename”,A1),FIND(”[",CELL("filename",A1))+1,FIND("]“,
CELL(”filename”,A1))-FIND(”[”,CELL(”filename”,A1))-1)
Note: Remove the line break from the formula in Excel.
Insert FileName Into a Cell
Leave a Comment
