Spreadsheet formulas explained, side by side

Text Functions

Joining, splitting, trimming, searching and changing case. Each function below has a side-by-side syntax table for Excel, Google Sheets, Airtable and Notion, a live tester, and one-click copy buttons.

FunctionWhat it doesExcelGoogle SheetsAirtableNotion
CONCATENATEJoin text together with &, CONCAT or CONCATENATE✔✔✔✔
TEXTJOINJoin a range of text with a delimiter, skipping blanks✔✔≈✔
LEFTTake characters from the start of text✔✔✔✔
RIGHTTake characters from the end of text✔✔✔≈
MIDTake characters from the middle of text✔✔✔✔
LENCount the characters in text✔✔✔✔
TRIMRemove extra spaces from text✔✔✔≈
UPPERConvert text to UPPERCASE✔✔✔✔
LOWERConvert text to lowercase✔✔✔✔
PROPERCapitalise the first letter of every word✔✔✘≈
SUBSTITUTEReplace specific text within a string✔✔✔✔
FINDPosition of text within text (case-sensitive)✔✔✔≈
SEARCHPosition of text within text (ignores case, wildcards)✔✔✔≈
SPLITSplit text into separate cells by a delimiter✔✔✘✔
REPTRepeat text a number of times✔✔✔✔
VALUEConvert text that looks like a number into a number✔✔✔✔
REGEXMATCHTest whether text matches a regular expression✔✔✔✔

✔ built-in function   ≈ works with a workaround formula   ✘ not available