Text Functions

Name	Description
`text_1 & text_2`	Equivalent to CONCATENTATE(text1, text_2).
`CONCATENTATE(text_1, [text2, ...])`	Append strings to one another.
`FIND(search_for, text_to_search, [starting_at])`	First position of string found in text, case-sensitive.
`LEFT(string, number_of_characters)`	Substring from beginning of the specified string.
`LEN(text)`	Length of a string.
`LOWER(text)`	Convert text to lowercase.
`MID(string, starting_at, extract_length)`	A segment of a string.
`RIGHT(string, number_of_characters)`	Substring from end of the specificed string.
`SEARCH(search_for, text_to_search, [starting_at])`	First position of string found in text, ignoring case.
`SUBSTITUTE(text_to_search, search_for, replace_with)`	Replaces existing text with new text in a string.
`TRIM(text)`	Remove leading and trailing spaces.
`UPPER(text)`	Convert text to uppercase.

Details

Equivalent to CONCATENTATE(text1, text_2).

Append strings to one another.

First position of string found in text, case-sensitive.

Substring from beginning of the specified string.

Length of a string.

Convert text to lowercase.

A segment of a string.

Substring from end of the specificed string.

First position of string found in text, ignoring case.

Replaces existing text with new text in a string.

Remove leading and trailing spaces.

Convert text to uppercase.