May 15 2019 01:50 AM
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
Thanks
May 15 2019 02:00 AM
@SuzanH , do you mean this https://support.office.com/en-ie/article/insert-the-current-excel-file-name-path-or-worksheet-in-a-c... formula?
It returns something like path\[filename.xlsx]Sheet1 and you'd like path\[filename]Sheet1, correct?
May 15 2019 11:09 PM