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