Hi
Learners, in this blog post I will share how you can get the Excel File name.
Select a
cell.
Type “=CELL”
& press TAB, select option “filename” & press TAB, close the bracket,
press ENTER.
This will
give you the whole address of the Sheet, including the file name, folder name
etc.
But we need
to take only the File name.
So, for
this purpose I will use MID, FIND Functions along with CELL.
Refer to
the below formula.
=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND(".",CELL("filename"))-FIND("[",CELL("filename"))-1)
No comments:
Post a Comment