Forum Discussion

DFClark's avatar
DFClark
Copper Contributor
Apr 13, 2022

How to access the file name in Excel 365

In Excel the name of the current spreadsheet file can be obtained using the CELL function with the info-type set to "filename".  In Excel 365 this is not supported ("Note: This value is not supported...
office 365
Guy_Boswell's avatar
Guy_Boswell
Brass Contributor
Oct 20, 2022
I wish I knew!
  • peterrosenberg's avatar
    peterrosenberg
    Copper Contributor
    Sep 14, 2023
    And if you only want your workbook filename (minus Path), you can use this trick:
    =TEXTBEFORE(TAKE(TEXTSPLIT(CELL("filename");"/";-1);;-1);"]")
    Provided you have the Excel 365 functions added Spring 2023 (DROP, TAKE, TEXTSPLIT).
    • Jay-likes-lasers's avatar
      Jay-likes-lasers
      Copper Contributor
      Apr 30, 2024

      peterrosenberg Using this solution, it returns me a filename which unfortunately starts with an additional "[" character. I tried using

      =TEXTAFTER("[",TEXTBEFORE(TAKE(TEXTSPLIT(CELL("filename"),"/",-1),,-1),"]"))

      but this returns #N/A. 

       

      I did a quick workaround, by using RIGHT() and LEN()-1; giving the desired result:

       

      =RIGHT(TEXTBEFORE(TAKE(TEXTSPLIT(CELL("filename"),"/",-1),,-1),"]"),LEN(TEXTBEFORE(TAKE(TEXTSPLIT(CELL("filename"),"/",-1),,-1),"]"))-1)

Resources