Learn Blog Pricing About Sign in

Learn

Blog

Pricing

About

Sign in

Text functions

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.
FORMATDATE Returns a date as text.
FORMATFRACTION Returns a number as text, formatted as an integer followed by a fraction (a denominator, a division symbol and a numerator).
FORMATNUMBER Returns a number as text.
FORMATPERCENTAGE Returns a number as text, representing a percentage.
FORMATSCIENTIFIC Returns a number formatted using scientific notation.
FORMATTIME Returns a time as text.
ISEMAIL Returns whether the given text string is probably an email address.
LEFT Returns text from the left side of a text string.
LEN Returns the length of a text string.
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.
PARSEDATE Interprets a text string as a date and returns it.
PARSEFRACTION Interprets a text string as a number and returns it, where the text string is expected to contain a fraction (a denominator, a division symbol and a numerator), optionally preceded by an integer.
PARSENUMBER Interprets a text string as a number and returns it.
PARSEPERCENTAGE Interprets a text string as a percentage and returns it.
PARSESCIENTIFIC Interprets a text string as a number and returns it, where said text string is expected to use scientific notation.
PARSETIME Interprets a text string as a time and returns it.
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 text from the right side of 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.
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.