Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Standard math to calculate Aspect Ratio Basic Math
  • Expenses calendar, FaCal Basic Math
  • Hello world! Uncategorized
  • Walking Columns ActiveX controls
  • IF with AND and IF with OR AND
  • Formula Beautifier Excel User tips
  • Insert Blank rows into table using functions CHAR
  • Extract Address into table Formulas - combined functions

Extract current (Active) workbook name

Posted on September 14, 2015 By ANmar

I need that more often than I thought

It is basically extract the full workbook name that we are in, with no folders, and with no extension

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

So, here it is….

 

And if we want to go 1 step further, I often have the version of the tool as part of the filename, to distinguish of the prior release, so below function will extract the version only, if we ever need to compare of the versions

=MID(CELL("filename",$A$1),SEARCH(" v",CELL("filename",$A$1))+2,SEARCH(".xl",CELL("filename",$A$1),SEARCH("[",CELL("filename",$A$1)))-SEARCH(" v",CELL("filename",$A$1))-2)
CELL, Formulas - combined functions, Information, Lookup and References, MID, SEARCH, Standard functions, Texts and Strings

Post navigation

Previous Post: Week number to Month number
Next Post: Workdays – Across months

Related Posts

  • Fx to cut long column into two columns Formulas - combined functions
  • MATCH fumction, just a simple search Lookup and References
  • Jan8 date format AND
  • Searching table in 2 dimensions. Formulas - combined functions
  • Worksheet name, dynamically using formula CELL
  • Multiple-Validations (connected to each other) Data Validation

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Recover the unrecoverable Excel User tips
  • Standard math to calculate Aspect Ratio Basic Math
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • CountIf limitation COUNTIF
  • Hello world! Uncategorized
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Tally chart in functions Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme