If you need to insert only filename without the extension at the header, footer, or a cell. Normally an open workbook’s filename and extension are displaying at the top of Excel window. Insert filename in header/footer/cell without extension in Excel This article will show you the way to get the last modified user name information, and insert the last modified user name information in cells in Excel. Get and insert the last modified user name in Excel If you want to have a free trial ( 30-day) of this utility, please click to download it, and then go to apply the operation according above steps. In the Insert Workbook Information dialog box, choose one workbook information in the Information section, specify where to insert the information in the Insert at section, and then click OK.Īs the below screenshot, the file name will be inserted in A2 after clicking the OK button. Select a cell to output the workbook information, click Kutools Plus > Workbook > Insert Workbook Information.

This feature can help to insert workbook information (such as sheet name, workbook name, workbook path as you need) into a certain cell, header or footer.īefore applying Kutools for Excel, please download and install it firstly.ġ. In this section, I introduce a handy tool – Insert Workbook Information utility of Kutools for Excel for you. In the above formulas, A1 is a variable, you can change it to any other cell reference.Įasily get workbook information (sheet name, file name/path, etc.) with an amazing tool Except the above formula, you can also use this formula: Enter or copy the below formula into it and press the Enter key to get the filename. Select a blank cell to output the workbook name.Ģ. The below formulas can help you to get the filename excluding the extension quickly, please do with following steps:ġ. Return filename without extension to cell with formulas Download Kutools for Excel now! ( 30-day free trail)

The Insert Workbook Information utility of Kutools for Excelcan help you easily insert workbook information in a cell, header or footer of a workbook as the below demo shown. Easily get workbook information (sheet name, file name, file path, etc.) in Excel:

Excel for mac return within a cell