ExcelBanter - Insert file name in header without showing extension

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Insert file name in header without showing extension (https://www.excelbanter.com/excel-discussion-misc-queries/257118-insert-file-name-header-without-showing-extension.html)

Cynergy

Insert file name in header without showing extension

I know how to get the filename into a header/footer. Is there any way to get
the filename in the header/footer WITHOUT showing the filename extension?

All times are GMT +1. The time now is 01:00 PM.