Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • 6174 Kaprekar’s constant Basic Math
  • Text-to-Columns, dynamically using formulas IFERROR
  • Custom fiscal year calendar (CFlex) Basic Math
  • Count Unique COUNTIF
  • Cells with additional spaces AND
  • Excel ad from early 90s Non-functions
  • Walking Columns ActiveX controls
  • MATCH fumction, just a simple search Lookup and References

Worksheet name, dynamically using formula

Posted on April 3, 2018 By ANmar

Get the name of the active worksheet in active workbook, using formulas only

This function needs to have workbook saved

Then, you just paste below formula into any cell …

Other than A1 🙂

 
=MID(CELL("filename",$A$1),SEARCH("]",CELL("filename",$A$1))+1,500)

 

 

CELL, MID, SEARCH

Post navigation

Previous Post: Text-to-Columns, dynamically using formulas
Next Post: Sheet() and Sheets()

Related Posts

  • Extract current (Active) workbook name CELL
  • GoLast to jump to last cell in a column CELL
  • CamelCase to Camel Case CHAR
  • Extract Address into table Formulas - combined functions
  • Text-to-Columns, dynamically using formulas IFERROR
  • Always get 1st name (or last) Formulas - combined functions

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
  • Excel Limits Excel User tips
  • Calculate hours between two cells ABS
  • Excel sessions – 2013 VS 2010 Excel User tips
  • When Excel functions are not enough Excel User tips
  • Excel Functions = XL f(x)s XLfxs
  • Validation based on another Validation COUNTA
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Paste Special Percentage Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme