I have been doing several Excel projects for a class that I am taking, and the majority of them are requiring that I insert a custom footer with the file name on the left side of some or all sheets in a workbook. However, I want it to display the name of the file, but not the file extension. The only two ways I can think of to use the file name in my footers would be to click the “Insert File Name” button, or manually enter the name of my workbook.
Excel for Mac Custom Footer Dialog
Is there a way for Excel to be able to automatically insert the file name without including its extension? Thanks!
