Text

Join, split, clean, search and format strings.

Function	What it does
ASC	Converts full-width characters to half-width.
BAHTTEXT	Spells a number as thai baht and satang.
CHAR	Returns the character for a character-set code.
CLEAN	Removes non-printable characters.
CODE	Numeric code of the first character.
CONCAT	Joins multiple text strings into one.
CONCATENATE	Joins several text strings into one.
CONTAINS	Checks if text contains substring.
DBCS	Converts half-width characters to full-width.
DOLLAR	Formats a number as currency text.
ENDSWITH	Checks if text ends with suffix.
EXACT	Checks if two text strings are identical.
FIND	Finds text within another text, case-sensitive.
FINDB	Finds text within text by bytes, case-sensitive.
FIXED	Formats a number as text with a fixed number of decimals.
JIS	Converts half-width characters to full-width (alias of DBCS).
JOIN	Joins values with delimiter.
LEFT	Returns leftmost characters from text.
LEFTB	Returns leftmost bytes from text.
LEN	Returns number of characters in text.
LENB	Returns number of bytes in text.
LOWER	Converts text to lowercase.
MID	Returns characters from middle of text.
MIDB	Returns bytes from middle of text.
NUMBERVALUE	Converts text to a number, locale-independent.
PROPER	Capitalizes the first letter of each word.
REGEXEXTRACT	Extracts the first regex match.
REGEXMATCH	True when text matches a regular expression.
REGEXREPLACE	Replaces regex matches with new text.
REGEXTEST	Whether text matches a regular expression.
REPLACE	Replaces characters by position.
REPLACEB	Replaces characters by byte position.
REPT	Repeats text a given number of times.
RIGHT	Returns rightmost characters from text.
RIGHTB	Returns rightmost bytes from text.
SEARCH	Finds text within another text, case-insensitive.
SEARCHB	Finds text within text by bytes, case-insensitive.
SPLIT	Splits text by delimiter into multiple cells.
STARTSWITH	Checks if text starts with prefix.
SUBSTITUTE	Replaces old text with new text.
T	Returns text if value is text, else empty.
TEXT	Formats number as text with given format.
TEXTAFTER	Returns text after a delimiter.
TEXTBEFORE	Returns text before a delimiter.
TEXTCAPITALIZE	Capitalizes first letter of text.
TEXTCENTER	Centers text with padding to reach specified length.
TEXTCOMPARE	Compares two texts and returns -1, 0, or 1.
TEXTCOUNT	Counts occurrences of substring in text.
TEXTINDENT	Indents text with specified number of characters.
TEXTJOIN	Joins text with delimiter, ignoring blanks.
TEXTPADLEFT	Pads text on the left with character to reach specified length.
TEXTPADRIGHT	Pads text on the right with character to reach specified length.
TEXTREVERSE	Reverses text.
TEXTSPLIT	Splits text by delimiters into an array.
TEXTSWAPCASE	Swaps uppercase and lowercase letters.
TEXTTITLE	Converts text to title case.
TEXTWRAP	Wraps text at specified width.
TRIM	Removes extra spaces from text.
UNICHAR	Returns the character for a unicode code point.
UNICODE	Returns unicode number of first character.
UPPER	Converts text to uppercase.
VALUE	Converts text string to a number.
VALUETOTEXT	Returns text from any value type.