Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to add Trendline to a chart in Excel
  • How to calculate average last N values in a table in Excel
  • Create Scatter Chart in Excel
  • Randomize/ Shuffle List in Excel
  • Excel Line Chart

References

  • How to reference named range different sheet in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • Count rows that contain specific values in Excel
  • How to get relative column numbers in a range in Excel
  • Lookup entire row in Excel

Data Validations

  • Data validation must not exist in list
  • Excel Data validation no punctuation
  • Excel Data validation only dates between
  • Excel Data validation allow weekday only
  • Excel Data validation require unique number

How to retrieve workbook name only in Excel

by

If you want to get the workbook name only (i.e. the file name without path or sheet name) you can do so with a rather long formula that uses the MID function along with the FIND function.

Formula

=MID(CELL("filename",A1),FIND("[",CELL
("filename",A1))+1,FIND("]",CELL("filename",A1))
-FIND("[",CELL("filename",A1))-1)

Explanation

How the formula works

The cell function is used to get the full file name and path:

CELL("filename",A1)

The result looks like this:

path[workbook.xlsm]sheetname

At the highest level, the MID function simply extracts the file name from the path and sheet. The starting position is calculated with FIND:

FIND("[",CELL("filename",A1))+1

The number of characters to extract is also calculated with FIND:

FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1

Post navigation

Previous Post:

DECIMAL function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • OR function Examples in Excel
  • Excel If, Nested If, And/Or Criteria Examples
  • How to return blank in place of #DIV/0! error in Excel
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel

Date Time

  • Get days before a date in Excel
  • How to calculate next anniversary date or birthday in Excel
  • Get project end date in Excel
  • How to get same date next month or previous month in Excel
  • Two ways to sum time over 30 minutes in Excel

Grouping

  • Map inputs to arbitrary values in Excel
  • Group times into unequal buckets in Excel
  • Group numbers with VLOOKUP in Excel
  • How to randomly assign people to groups in Excel
  • If cell contains one of many things in Excel

General

  • Flash Fill in Excel
  • Freeze and Unfreeze Panes in Excel
  • Lock Cells in a Worksheet Excel
  • How to generate random times at specific intervals in Excel
  • Basic text sort formula in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning