Autonumber
Formula Reference
Description (from Formula Reference)
1
1
UPPER()

Makes string uppercase.

2
2
LOWER()

Makes a string lowercase.

3
3
LEN()

Returns the length of a string.

4
4
CONCATENATE()

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.

5
5
REPT()

Repeats string by the specified number of times.

6
6
TRIM()

Removes whitespace at the beginning and end of string.

7
7
RIGHT()

Extract howMany characters from the end of the string.

8
8
LEFT()

Extract how many characters from the beginning of the string.

9
9
MID()

Extract a substring of count characters starting at whereToStart.

10
10
FIND()

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.

11
11
SEARCH()

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.


12
12
SUBSTITUTE()

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.

13
13
REPLACE()

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


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!
Text functions
apples and bananas and cats
apples%20and%20bananas%20and%20cats%20
Text functions
APPLES AND BANANAS
APPLES%20AND%20BANANAS%20
Text functions
apples and bananas
apples%20and%20bananas
Text functions
cool things
cool%20things
Text functions
apples and bananas
apples%20and%20bananas
Text functions
<- spaces ->
%20%3C-%20spaces%20-%3E%20
Text functions
apples and bananas
apples%20and%20bananas
Text functions
apples and bananas
apples%20and%20bananas
Text functions
apples and bananas
apples%20and%20bananas
Text functions
apples and bananas
apples%20and%20bananas
Text functions
apples and bananas
apples%20and%20bananas
Text functions
apples and bananas
apples%20and%20bananas
Text functions
apples and bananas
apples%20and%20bananas
18 records
Extensions

Alert

Lorem ipsum
Okay