Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Insert Blank rows into table using functions CHAR
  • OFFSET+MATCH Formulas - combined functions
  • Sorting with functions only CHOOSE
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • iframe in Excel (XLiFrame) ADDRESS
  • Blank (isempty) VS “” (null string) Excel User tips
  • Jan8 date format AND
  • The Excel “&” bug Excel User tips

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

  • Always get 1st name (or last) Formulas - combined functions
  • GoLast to jump to last cell in a column CELL
  • MID + SEARCH to convert cell to rows MID
  • Middle name + 1st name Basic Math
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Extract current (Active) workbook name CELL

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
  • Repeated Offset Basic Math
  • Zipcode-State search Formulas - combined functions
  • CamelCase to Camel Case CHAR
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Multiple-Validations (connected to each other) Data Validation
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Excel Limits Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme