Forum Discussion
WittyGuy55
Jun 25, 2024Copper Contributor
EXCEL
Is there an EXCEL function that returns the current (open) filename?
Is there an EXCEL function that returns the current (open) worksheet name?
Perhaps
=TEXTBEFORE(TEXTAFTER(CELL("filename", A1), "["), "]")
and
=TEXTAFTER(CELL("filename", A1), "]")
3 Replies
Sort By
- WittyGuy55Copper ContributorThanks, Hans. I continue to be amazed at the power of EXCEL. Sometimes I just need a tip from an expert. Thanks again, David Hill in Florida, USA.
You may use =CELL("filename") and parse returned text. If only you are not on Excel for Web.
Lot of samples how to use, google for them.
Perhaps
=TEXTBEFORE(TEXTAFTER(CELL("filename", A1), "["), "]")
and
=TEXTAFTER(CELL("filename", A1), "]")