Forum Discussion
Solved
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), "]")
- Thanks, 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), "]")
