Browse formulas
Choose a formula page for copy-paste examples, step-by-step notes, and common mistakes.
fx
Remove Duplicates Formula
Return a de-duplicated list.
fxFIND Duplicates Formula
Identify duplicate values.
fxHighlight Duplicates Formula
Use a formula rule to highlight duplicates.
fxExtract Numbers From TEXT Formula
Extract digits from a text value.
fxExtract TEXT Before Delimiter Formula
Extract text before a symbol.
fxExtract TEXT After Delimiter Formula
Extract text after a symbol.
fxCombine First AND Last Name Formula
Join first and last names cleanly.
fxSeparate First Name Formula
Extract first name from a full name.
fxSeparate Last Name Formula
Extract last name from a full name.
fxRemove Line Breaks Formula
Replace line breaks with spaces.
fxCLEAN Phone Numbers Formula
Clean phone number punctuation.
fxConvert TEXT Dates Formula
Convert dates stored as text into real dates.
fxConvert Numbers Stored As TEXT Formula
Convert numeric text into numbers.
fxDynamic Named Range Formula
Create a dynamic range that grows with data.
fxConditional Formatting Formula
Apply a formatting rule with a formula.
fxData Validation List Formula
Create a dynamic list for dropdown validation.