Skip to main content

How to return filename without extension to cell in Excel?

In Excel, we can apply some ways to insert the workbook name with its extension in a specific cell, such as XLSX, XLSM. Sometimes, you may want to just insert the filename without the extension, how could you deal with this problem in Excel?

Return filename without extension to cell with formulas
Easily get workbook information (sheet name, file name/path, etc.) with an amazing tool

More tutorials for getting workbook information...


Return filename without extension to cell with formulas

The below formulas can help you to get the filename excluding the extension quickly, please do with following 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.

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.

Before applying Kutools for Excel, please download and install it firstly.

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.

  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.


Related articles

Get and insert the last modified user name 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.

Insert filename in header/footer/cell without extension in Excel
Normally an open workbook’s filename and extension are displaying at the top of Excel window. If you need to insert only filename without the extension at the header, footer, or a cell. How to solve it? This article will introduce methods to get it done.

Insert last saved timestamp into worksheet cell in Excel
In many cases, you may need to show the last saved date and time of an Excel workbook in order to know when the file was updated recently. Try methods in this article.

Insert page number into cell / header / footer in Excel
When you print an Excel file, you may need to insert the page numbers into the pages to make the printed file neatly and readably. This tutorial introduces some quick tricks to insert the page numbers into cell, header or footer for you.

More tutorials for getting workbook information...

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Description


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (11)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
FYI, it doesn't work if you only have one TAB. It was giving me an error, until I added a 2nd tab.
This comment was minimized by the moderator on the site
Thanks! But only this formula works: =TRIM(LEFT(SUBSTITUTE(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),".xl",REPT(" ",255)),255)) WHILE =MID(CELL("filename",A1),SEARCH("[",CELL("filename",A1))+1,SEARCH(".",CELL("filename",A1))-1-SEARCH("[",CELL("filename",A1))) does not work!
This comment was minimized by the moderator on the site
Thanks a lot dear..........
This comment was minimized by the moderator on the site
Thank you so much. this formula very helpful for me.
This comment was minimized by the moderator on the site
thank you so much for putting this up. Made my work simple
This comment was minimized by the moderator on the site
That works well BUT on a Mac you have to replace every , by a ;
This comment was minimized by the moderator on the site
Just returns #VALUE!.... terrible instructions.
This comment was minimized by the moderator on the site
Hello!



The formula above seems inactive if converted into a .zip folder. Is there a way out?



Thank you!
This comment was minimized by the moderator on the site
this works well . thank you
This comment was minimized by the moderator on the site
I can't get this to work in an .xlsmfile. Any ideas on what to do in an .xlsm file?

Thanks!

Deb
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations