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

Data Analysis

  • How to create dynamic reference table name in Excel
  • Use Data Form to input, edit and delete records in Excel
  • How to calculate average last N values in a table in Excel
  • How to calculate correlation coefficient Correlation in Excel
  • How To Sort One Column or Multiple Columns in Excel

References

  • How to get last row in mixed data with blanks in Excel
  • How to use Excel TRANSPOSE Function
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to create dynamic named range with OFFSET in Excel
  • How to use Excel LOOKUP Function

Data Validations

  • Excel Data validation allow uppercase only
  • Excel Data validation no punctuation
  • Excel Data validation number multiple 100
  • Excel Data validation don’t exceed total
  • Excel Data validation exists in list

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

  • Check multiple cells are equal in Excel
  • How to use Excel FALSE Function
  • Excel If, Nested If, And/Or Criteria Examples
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • How to use IFS function in Excel

Date Time

  • DATE function: Description, Usage, Syntax, Examples and Explanation
  • Display Days in month in Excel
  • Get first day of previous month in Excel
  • WORKDAY function: Description, Usage, Syntax, Examples and Explanation
  • WEEKDAY function: Description, Usage, Syntax, Examples and Explanation

Grouping

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

General

  • Basic error trapping example in Excel
  • How to generate random number weighted probability in Excel
  • Subtotal by color in Excel
  • Basic text sort formula in Excel
  • List sheet names with formula in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning