Forum Discussion

SuzanH's avatar
SuzanH
Copper Contributor
May 15, 2019

Insert File name via an array formula

I've just discovered this tool, fantastic.   BUT, can the field be amended to remove the file extension?  I want to use the field within a report as the document reference, but without the .xlsx T...
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
May 15, 2019
This formula returns the file name without the file extension:
=MID(CELL("filename",A1),
FIND("[",CELL("filename",A1))+1,
FIND(".x",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)