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

Data Analysis

  • How To Create Frequency Distribution in Excel
  • Conditional Formatting New Rule with Formulas in Excel
  • Move chart to a separate worksheet in Excel
  • Conditional Formatting Rules in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel

References

  • How to retrieve first match between two ranges in Excel
  • Lookup entire row in Excel
  • How to use Excel MMULT Function
  • Two-column Lookup in Excel
  • Find closest match in Excel

Data Validations

  • Excel Data validation don’t exceed total
  • How To Create Drop-down List in Excel
  • Data validation must not exist in list
  • Excel Data validation only dates between
  • Excel Data validation allow uppercase only

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
  • NOT function: Description, Usage, Syntax, Examples and Explanation
  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • IF, AND, OR and NOT Functions Examples in Excel

Date Time

  • Assign points based on late time in Excel
  • How to calculate next day of week in Excel
  • Convert decimal seconds to Excel time
  • How to calculate Quarter of Date in Excel
  • Get fiscal quarter from date in Excel

Grouping

  • Group times into 3 hour buckets in Excel
  • Group times into unequal buckets in Excel
  • How to randomly assign people to groups in Excel
  • How to randomly assign data to groups in Excel
  • Map text to numbers in Excel

General

  • How to password protect excel sheet?
  • How to count total number of cells in a rectangular range in Excel
  • Find, Trace and Correct Errors in Excel Formulas using ‘Formula Auditing’
  • Creating and Opening an existing file in Excel
  • Excel Default Templates
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning