Text Functions
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. | ![]() |