How to return filename without extension in Excel?

Working with filenames in Excel can sometimes be tricky, especially when you need to extract only the filename without its extension. This guide will cover two effective methods to extract and display the filename without the extension.

Return filename without extension with formulas
Return filename without extension with Kutools AI Aide
Easily get workbook information (sheet name, file name/path, etc.) with an amazing tool
More tutorials for getting workbook information...

Return filename without extension with formulas

The following formulas can help you quickly get the filename without the extension. Follow these steps:

1. Select a blank cell to output the workbook name.

2. Enter or copy the below formula into it and press the Enter key to get the filename.

=MID(CELL("filename",A1),SEARCH("[",CELL("filename",A1))+1,SEARCH(".",CELL("filename",A1))-1-SEARCH("[",CELL("filename",A1)))

Notes:

• 1. Except the above formula, you can also use this formula:
  

  =TRIM(LEFT(SUBSTITUTE(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),".xl",REPT(" ",255)),255))

• 2. In the above formulas, A1 is a variable, you can change it to any other cell reference.

Return filename without extension with Kutools AI Aide

For users who prefer a faster and more intuitive approach, the Kutools for Excel offers a convenient solution. Kutools AI Aide simplifies complex operations with just a few clicks.

After installing Kutools For Excel, please click Kutools > AI Aide to open the Kutools AI Aide pane.

1. Click to select a cell to output the result.
2. Then, type the requirement in the chat box: such as:
   Return this workbook name without extension in selected cell
3. And then, press Enter key or click the Send button. Kutools AI will analyze the question, after finishing, please click Execute button to get the result.

Easily get workbook information (sheet name, file name/path, etc.) with an amazing tool

In this section, I introduce a handy tool – Insert Workbook Information utility of Kutools for Excel for you. 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.

1. Select a cell to output the workbook information, click Kutools Plus > Workbook > Insert Workbook Information. See screenshot:

2. 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.

As the below screenshot, the file name will be inserted in A2 after clicking the OK button.

Extracting filenames without extensions in Excel is straightforward with the right tools and methods. Choose the method that best suits your needs and workflow. If you're interested in exploring more Excel tips and tricks, our website offers thousands of tutorials.

Related articles