Text Functions

Note: Each function has an article associated with it, click the link or image to navigate there.

CAPITALIZE Changes the first letter in each word to upper case.
CONCAT Concatenates a set of values into a single string.
CONTAINS Tests each value in haystack to see if it contains value specified in needle.
INDEXOF Returns a vector of data containing the index position of the first occurrence of search text.
JOIN Takes a set of values and joins those values with a comma.
LASTINDEXOF Returns a vector of data containing the index position of the last occurrence of search text.
LEFT Returns the specified number of leftmost characters in a text string.
LOWER Changes all characters within a selected range to lower case.
NUMBERFORMAT Takes a set of values, treats them as numbers and return them as text.
REMOVE_EMOJI Strips emojis from selected data so the remaining data can be processed.
RIGHT Returns the specified number of rightmost characters in a text string.
SUBSTITUTE Takes a selection of values and replaces them with the text provided.
SUBSTITUTE_REGEX Same as SUBSTITUTE except old text is treated as a regular expression.
SUBSTRING Returns a substring of text from a text string.
TEXT_REVERSE Reverses the order of text or numbers in a cell or selected range of cells.
TRUNCATE Choose the number of characters to hide from either the start or end points of your data selection.
UPPER Changes all characters within specified range to upper case.
URLDECODE Decodes data that is encoded for use in a URL to plain text (UTF-8).
URLENCODE Encodes data to be safely used in URLs.