Forum Discussion

WittyGuy55's avatar
WittyGuy55
Copper Contributor
Jun 25, 2024
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?
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jun 25, 2024

    WittyGuy55 

    Perhaps

    =TEXTBEFORE(TEXTAFTER(CELL("filename", A1), "["), "]")

    and

    =TEXTAFTER(CELL("filename", A1), "]")

HansVogelaar's avatar
HansVogelaar
MVP
Jun 25, 2024

WittyGuy55 

Perhaps

=TEXTBEFORE(TEXTAFTER(CELL("filename", A1), "["), "]")

and

=TEXTAFTER(CELL("filename", A1), "]")

Resources