Display working folder name in a cell

[aerobharath15]

HI,

When I open this excel file, i want a particular cell to show the name of the folder this excel file is in. I would like a formula that displays only the folder name and not the full file path. thanks in advance.

 

[AlanY]

try

=TRIM(RIGHT(SUBSTITUTE(LEFT(CELL("filename",A1),SEARCH("[",CELL("filename",A1))-2),"\",REPT(" ",20)),20))

 

[aerobharath15]

try

=TRIM(RIGHT(SUBSTITUTE(LEFT(CELL("filename",A1),SEARCH("[",CELL("filename",A1))-2),"\",REPT(" ",20)),20))

SIMPLY WOWWW.. thanks Alan

Please can you also help me with the below?

How to display the current account user of MS EXCEL in a cell?

thanks

 

[AlanY]

what's =CELL("filename",A1) produced?