TRUNC Function in Excel: Cut Off Decimals Without Rounding
TRUNC drops digits after a given point, moving towards zero. Unlike INT, TRUNC(−8.9) is −8.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
QUOTIENT Function in Excel: Whole-Number Division
QUOTIENT Function in Excel: Whole-Number Division
QUOTIENT returns only the integer part of a division; MOD returns the remainder.
Read article →NOT Function in Excel: Reverse TRUE and FALSE
NOT Function in Excel: Reverse TRUE and FALSE
LogicalLevel: BeginnerAvailable in: Excel 2007+NOT flips TRUE to FALSE and back — useful for “everything except”.
Read article →FINDB Function in Excel: Find Position in Bytes
FINDB Function in Excel: Find Position in Bytes
TextLevel: ExpertAvailable in: Excel 2007+FINDB is the byte-based version of FIND.Syntax=FINDB("b",text)ArgumentWhat it meanstextText to work.
Read article →ISBLANK Function in Excel: Is the Cell Truly Empty?
ISBLANK Function in Excel: Is the Cell Truly Empty?
ISBLANK returns TRUE only for truly empty cells. A formula returning "" is not blank to ISBLANK — a common surprise.
Read article →LEFTB Function in Excel: Leftmost Bytes
LEFTB Function in Excel: Leftmost Bytes
LEFTB returns the first characters based on bytes. In English (single-byte) setups it behaves exactly like LEFT; it differs only when a double-byte language…
Read article →RIGHTB Function in Excel: Rightmost Bytes
RIGHTB Function in Excel: Rightmost Bytes
RIGHTB is the byte-based version of RIGHT; identical to RIGHT in English setups.
Read article →FIND Function in Excel: Position of Text (Case-Sensitive)
FIND Function in Excel: Position of Text (Case-Sensitive)
FIND returns where one text starts inside another. It is case-sensitive and does not allow wildcards — use SEARCH for that.
Read article →MID Function in Excel: Extract Text From the Middle
MID Function in Excel: Extract Text From the Middle
MID returns characters from the middle of a text, starting at a position you choose.
Read article →RIGHT Function in Excel: Take Characters From the End of Text
RIGHT Function in Excel: Take Characters From the End of Text
TextLevel: BeginnerAvailable in: Excel 2007+RIGHT returns the last characters of a text value.Syntax=RIGHT(text, [num_chars])ArgumentWhat it meanstextThe.
Read article →LEN Function in Excel: Count Characters in Text
LEN Function in Excel: Count Characters in Text
TextLevel: BeginnerAvailable in: Excel 2007+LEN returns the number of characters, including spaces.Syntax=LEN(text)ArgumentWhat it meanstextText or a.
Read article →LEFT Function in Excel: Take Characters From the Start of Text
LEFT Function in Excel: Take Characters From the Start of Text
TextLevel: BeginnerAvailable in: Excel 2007+LEFT returns the first characters of a text. RIGHT takes them from the end.Syntax=LEFT(text.
Read article →