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.|
||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.|