Text

48 functions in this section.

CHAR	Returns a single text character, identified by a Unicode code point.
CHARAT	Returns the character at the given position.
CLEAN	Cleans text from certain non-printable characters and returns it.
CODE	Returns the Unicode code point for the first character of the given text string.
CONCAT	Joins any number of values together as a single text string and returns it.
CONCATENATE	Joins any number of values together as a single text string and returns it.
CONTAINS	Returns whether a text string contains another text string.
ENDSWITH	Returns whether a text string ends with another text string.
EXACT	Returns whether the two text strings are identical, in terms of content and in terms of case.
FIND	Finds a text string nestled within another text string and returns its position.
FIXED	Returns a number as text with a specified format.
FORMAT	Returns a number as text.
FORMAT.CURRENCY	Returns a monetary value as text.
FORMAT.DATE	Returns a date as text.
FORMAT.DATETIME	Returns a date and a time as text.
FORMAT.ENGINEERING	Returns a number formatted using engineering notation.
FORMAT.FRACTION	Returns a number as text, formatted as an integer followed by a fraction (a denominator, a division symbol and a numerator).
FORMAT.PERCENTAGE	Returns a number as text, representing a percentage.
FORMAT.SCIENTIFIC	Returns a number formatted using scientific notation.
FORMAT.TIME	Returns a time as text.
ISEMAIL	Returns whether the given text string is probably an email address.
LEFT	Returns the first characters from a text string.
LEN	Returns the length of a text string.
LOCALE	Returns a locale based on the given parameters.
LOWER	Converts all upper-case letters in a text string to lower-case letters and returns the converted string.
MID	Returns text from any part of a text string, effectively returning a substring.
NEWLINE	Returns a line break character, which causes the character following it to appear on the next line.
PROPER	Returns a version of the given text string using "proper" capitalization.
REGEXEXTRACT	Extracts the parts of a text string identified by a JavaScript regular expression and returns the extracted text.
REGEXEXTRACTALL	Extracts the parts of a text string identified by a JavaScript regular expression and returns an array with the extracted text.
REGEXMATCH	Returns whether a given text string matches a JavaScript regular expression.
REGEXREPLACE	Replaces the parts of a text string that match a JavaScript regular expression and returns the result.
REGEXSPLIT	Divides a text string into parts using a regular expression as a delimiter, returning the parts as an array.
REPLACE	Replaces a part of a text string with a different text string and returns the result.
REPT	Repeats a given text string a certain number of times and returns it.
REVERSE	Reverses the given text string and returns it.
RIGHT	Returns the last characters from a text string.
SEARCH	Finds a text string nestled within another text string and returns its position.
STARTSWITH	Returns whether a text string starts with another text string.
SUBSTITUTE	Substitutes new text for old text in a text string and returns it.
TEXTAFTER	Returns the text which follows a delimiter in a text string.
TEXTBEFORE	Returns the text which precedes a delimiter in a text string.
TEXTJOIN	Joins a number of values together, separating them with a delimiter, and returns the resulting text string.
TEXTSPLIT	Divides a text string into parts using a delimiter, returning the parts as an array.
TRIM	Removes any excess whitespace characters (such as space characters) from a text string and returns the modified text string.
UNICHAR	Returns a single text character, identified by a Unicode code point.
UNICODE	Returns the Unicode code point for the first character of the given text string.
UPPER	Converts all lower-case letters in a text string to upper-case letters and returns the converted string.