Text Functions 🧠 (1)

Status	Function	Description
Not started	COMBINEVALUES	Joins two or more text strings into one text string.
Not started	CONCATENATE	Joins two text strings into one text string.
Not started	CONCATENATEX	Concatenates the result of an expression evaluated for each row in a table.
Not started	EXACT	Compares two text strings and returns `TRUE` if they are exactly the same, `FALSE` otherwise.
Not started	FIND	Returns the starting position of one text string within another text string.
Not started	FIXED	Rounds a number to the specified number of decimals and returns the result as text.
Not started	FORMAT	Converts a value to text according to the specified format.
Not started	LEFT	Returns the specified number of characters from the start of a text string.
Not started	LEN	Returns the number of characters in a text string.
Not started	LOWER	Converts all letters in a text string to lowercase.
Not started	MID	Returns a string of characters from the middle of a text string, given a starting position and length.
Not started	REPLACE	REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.
Not started	REPT	Repeats text a given number of times.
Not started	RIGHT	RIGHT returns the last character or characters in a text string, based on the number of characters you specify.
Not started	SEARCH	Returns the number of the character at which a specific character or text string is first found, reading left to right.
Not started	SUBSTITUTE	Replaces existing text with new text in a text string.
Not started	TRIM	Removes all spaces from text except for single spaces between words.
Not started	UNICHAR	Returns the Unicode character referenced by the numeric value.
Not started	UNICODE	Returns the numeric code corresponding to the first character of the text string.
Not started	UPPER	Converts a text string to all uppercase letters.
Not started	VALUE	Converts a text string that represents a number to a number.