REGEXEXTRACT Function in Excel: Pull Text That Matches a Pattern
REGEXEXTRACT returns the part of text that matches a pattern — invoice numbers, phone numbers, amounts buried in narration.
Read article →ISFORMULA Function in Excel: Does the Cell Hold a Formula?
ISFORMULA Function in Excel: Does the Cell Hold a Formula?
ISFORMULA returns TRUE when a cell contains a formula. Use it in conditional formatting to catch numbers someone typed over a formula column.
Read article →SEARCH Function in Excel: Position of Text (Any Case, Wildcards)
SEARCH Function in Excel: Position of Text (Any Case, Wildcards)
SEARCH works like FIND but ignores case and accepts wildcards (? and *). With ISNUMBER it becomes a “contains” test.
Read article →TEXTAFTER Function in Excel: Text After a Delimiter
TEXTAFTER Function in Excel: Text After a Delimiter
TEXTAFTER returns the text that follows a delimiter — domains from emails, surnames, file extensions.
Read article →DROP Function in Excel: Remove First or Last Rows
DROP Function in Excel: Remove First or Last Rows
DROP removes rows or columns from the start (positive) or end (negative) of an array — e.g. strip headers or total rows.
Read article →ISREF Function in Excel: Is It a Valid Reference?
ISREF Function in Excel: Is It a Valid Reference?
ISREF returns TRUE when its argument is a reference. With INDIRECT it checks whether a sheet name typed by a user exists.
Read article →SMALL Function in Excel: The k-th Smallest Value
SMALL Function in Excel: The k-th Smallest Value
StatisticalLevel: IntermediateAvailable in: Excel 2007+SMALL returns the k-th smallest number — bottom-N lists and the earliest dates.Syntax=SMALL(array.
Read article →VALUETOTEXT Function in Excel: Any Value as Text
VALUETOTEXT Function in Excel: Any Value as Text
VALUETOTEXT converts any value to text; strict mode adds quotes around text so you can see stray spaces.
Read article →CUBEVALUE Function in Excel: Numbers Straight From the Data Model
CUBEVALUE Function in Excel: Numbers Straight From the Data Model
CUBEVALUE pulls a measure from the Power Pivot Data Model into any cell, so you can build free-form reports instead of being stuck with…
Read article →ADDRESS Function in Excel: Build a Cell Address as Text
ADDRESS Function in Excel: Build a Cell Address as Text
ADDRESS returns a cell reference as text from row and column numbers — often combined with MATCH to report “where” something is.
Read article →COLUMN Function in Excel: Column Number of a Cell
COLUMN Function in Excel: Column Number of a Cell
COLUMN returns the column number (A = 1). Handy for VLOOKUP formulas that fill across.
Read article →LAMBDA Function in Excel: Create Your Own Excel Functions
LAMBDA Function in Excel: Create Your Own Excel Functions
LAMBDA turns a formula into a reusable custom function. Save it in Name Manager and use it like any built-in function — no VBA.
Read article →