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.
| Function | What it does | Excel | Google Sheets | Airtable | Notion |
|---|---|---|---|---|---|
| CONCATENATE | Join text together with &, CONCAT or CONCATENATE | ✔ | ✔ | ✔ | ✔ |
| TEXTJOIN | Join a range of text with a delimiter, skipping blanks | ✔ | ✔ | ≈ | ✔ |
| LEFT | Take characters from the start of text | ✔ | ✔ | ✔ | ✔ |
| RIGHT | Take characters from the end of text | ✔ | ✔ | ✔ | ≈ |
| MID | Take characters from the middle of text | ✔ | ✔ | ✔ | ✔ |
| LEN | Count the characters in text | ✔ | ✔ | ✔ | ✔ |
| TRIM | Remove extra spaces from text | ✔ | ✔ | ✔ | ≈ |
| UPPER | Convert text to UPPERCASE | ✔ | ✔ | ✔ | ✔ |
| LOWER | Convert text to lowercase | ✔ | ✔ | ✔ | ✔ |
| PROPER | Capitalise the first letter of every word | ✔ | ✔ | ✘ | ≈ |
| SUBSTITUTE | Replace specific text within a string | ✔ | ✔ | ✔ | ✔ |
| FIND | Position of text within text (case-sensitive) | ✔ | ✔ | ✔ | ≈ |
| SEARCH | Position of text within text (ignores case, wildcards) | ✔ | ✔ | ✔ | ≈ |
| SPLIT | Split text into separate cells by a delimiter | ✔ | ✔ | ✘ | ✔ |
| REPT | Repeat text a number of times | ✔ | ✔ | ✔ | ✔ |
| VALUE | Convert text that looks like a number into a number | ✔ | ✔ | ✔ | ✔ |
| REGEXMATCH | Test whether text matches a regular expression | ✔ | ✔ | ✔ | ✔ |
✔ built-in function ≈ works with a workaround formula ✘ not available