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

Data Analysis

  • How to calculate current stock or inventory in Excel
  • How to Sort by Color in Excel
  • Get column index in Excel Table
  • Remove Duplicates Example in Excel
  • How to combine 2 or more chart types in a single chart in Excel

References

  • How to calculate two-way lookup VLOOKUP in Excel Table
  • To count total rows in a range in Excel
  • How to use Excel ROWS Function
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Two-way lookup with VLOOKUP in Excel

Data Validations

  • Excel Data validation don’t exceed total
  • Excel Data validation allow weekday only
  • Prevent invalid data entering in specific cells
  • Excel Data validation only dates between
  • Excel Data validation must not contain

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

  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • Nested IF function example in Excel
  • How to use Excel TRUE Function
  • Extract multiple matches into separate rows in Excel
  • How to use Excel FALSE Function

Date Time

  • Count day of week between dates in Excel
  • Get age from birthday in Excel
  • How to join date and text together in Excel
  • YEARFRAC function: Description, Usage, Syntax, Examples and Explanation
  • Get days between dates ignoring years in Excel

Grouping

  • Map text to numbers in Excel
  • Calculate conditional mode with criteria in Excel
  • Group times into unequal buckets in Excel
  • Group arbitrary text values in Excel
  • Group numbers with VLOOKUP in Excel

General

  • Lock Cells in a Worksheet Excel
  • How to count total columns in range in Excel
  • Subtotal invoices by age in Excel
  • Zoom Worksheet in Excel
  • Sum by group in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning