Forum Discussion
himmaugh
Sep 21, 2022Copper Contributor
How to add file name to excel document
was on dinosaur MS Office 2007; now on MS 365; my question is how to add the docūment file name to an excel worksheet; i remember doing this on the dinosaur so, I am assuming it can still be done; th...
JMB17
Sep 22, 2022Bronze Contributor
If you have these text functions, then you could try:
=TEXTBEFORE(TEXTAFTER(CELL("filename"), "["), "]")
=TEXTBEFORE(TEXTAFTER(CELL("filename"), "["), "]")