Formula Playground
Copy base
Report abuse
Views
Autonumber
Formula Reference
1
1
UPPER()
2
2
LOWER()
3
3
LEN()
4
4
CONCATENATE()
5
5
REPT()
6
6
TRIM()
7
7
RIGHT()
8
8
LEFT()
9
9
MID()
10
10
FIND()
11
11
SEARCH()
12
12
SUBSTITUTE()
13
13
REPLACE()
Cannot adjust frozen columns; click to learn more or reset
Formula Data Type (from Formula Reference)
Example text
ENCODE_URL_COMPONENT(string)
TRIM(string)
LOWER(string)
UPPER(string)
MID(string, whereToStart, count)
RIGHT(string, count)
LEFT(string, count)
LEN(string)
SEARCH(stringToFind, whereToSearch,[startFromPosition])
SUBSTITUTE(string, old_text, new_text, [index])
REPLACE(string, startCharacter, numberOfCharacters, replacement)
FIND(stringToFind, whereToSearch,[startFromPosition])
CONCATENATE(text1, [text2, ...])
REPT(string, number)
T(value) — check out this formula!
Description (from Formula Reference)

Makes string uppercase.

Text functions
apples and bananas and cats

Makes a string lowercase.

Text functions
APPLES AND BANANAS

Returns the length of a string.

Text functions
apples and bananas

Joins together the text arguments into a single text value.

To concatenate static text, surround it with double quotation marks. To concatenate double quotation marks, you need to use a backslash (\) as an escape character.

Text functions
cool things

Repeats string by the specified number of times.

Text functions
apples and bananas

Removes whitespace at the beginning and end of string.

Text functions
<- spaces ->

Extract howMany characters from the end of the string.

Text functions
apples and bananas

Extract how many characters from the beginning of the string.

Text functions
apples and bananas

Extract a substring of count characters starting at whereToStart.

Text functions
apples and bananas

Finds an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition.(startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be 0.

Similar to SEARCH(), though SEARCH() returns empty rather than 0 if no occurrence of stringToFind is found.

Text functions
apples and bananas

Searches for an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition. (startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be empty.


Text functions
apples and bananas

Replaces occurrences of old_text with new_text.

You can optionally specify an index number (starting from 1) to replace just a specific occurrence of old_text. If no index number is specified, then all occurrences of old_text will be replaced.

Text functions
apples and bananas

Replaces the number of characters beginning with the start character with the replacement text.


Text functions
apples and bananas
18 records
  • All — use the below views to filter between examples!
  • UPPER()
  • LOWER()
  • LEN()
  • CONCATENATE()
  • REPT()
  • TRIM()
  • RIGHT()
  • LEFT()
  • MID()
  • FIND()
  • SEARCH()
  • SUBSTITUTE()
  • REPLACE()
  • T()
  • ENCODE_URL_COMPONENT()
Extensions

Alert

Lorem ipsum
Okay