Browse formulas
Choose a formula page for copy-paste examples, step-by-step notes, and common mistakes.
CONCAT Formula
Join text from multiple cells.
fxTEXTJOIN Formula
Join many text values with a delimiter.
fxCONCATENATE Formula
Join text using the older concatenate function.
fxLEFT Formula
Return characters from the left side of text.
fxRIGHT Formula
Return characters from the right side of text.
fxMID Formula
Return characters from the middle of text.
fxLEN Formula
Count the number of characters in text.
fxTRIM Formula
Remove extra spaces from text.
fxCLEAN Formula
Remove non-printing characters.
fxSUBSTITUTE Formula
Replace specific text with new text.
fxREPLACE Formula
Replace text by position.
fxTEXT Formula
Format numbers or dates as text.
fxVALUE Formula
Convert text that looks like a number into a number.
fxNUMBERVALUE Formula
Convert text to a number with custom decimal/group separators.
fxFIND Formula
Find text position case-sensitively.
fxSEARCH Formula
Find text position without case sensitivity.
fxEXACT Formula
Compare two text values exactly.
fxUPPER Formula
Convert text to uppercase.
fxLOWER Formula
Convert text to lowercase.
fxPROPER Formula
Capitalize the first letter of each word.
fxTEXTSPLIT Formula
Split text into columns or rows.
fxTEXTBEFORE Formula
Return text before a delimiter.
fxTEXTAFTER Formula
Return text after a delimiter.