Text Functions

Status

Not started

Status	Column 1	Title	Text
Not started	Function	Description
Not started	ASC	Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
Not started	ARRAYTOTEXT (2021)	Returns an array of text values from any specified range
Not started	BAHTTEXT	Converts a number to text, using the ß (baht) currency format
Not started	CHAR	Returns the character specified by the code number
Not started	CLEAN	Removes all nonprintable characters from text
Not started	CODE	Returns a numeric code for the first character in a text string
Not started	CONCAT (2019)	Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
Not started	CONCATENATE	Joins several text items into one text item
Not started	DBCS (2013)	Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters
Not started	DETECTLANGUAGE (Microsoft 365)	Identifies the language of a specified text
Not started	DOLLAR	Converts a number to text, using the $ (dollar) currency format
Not started	EXACT	Checks to see if two text values are identical
Done	FIND, FINDB	Finds one text value within another (case-sensitive)	`FIND(find_text, within_text, [start_num])`
Not started	FIXED	Formats a number as text with a fixed number of decimals
Done	LEFT, LEFTB	Returns the leftmost characters from a text value	`LEFT(text, [num_chars])`
Not started	LEN, LENB	Returns the number of characters in a text string	`LEN(text)`
Not started	LOWER	Converts text to lowercase	`LOWER(text)`
Not started	MID, MIDB	Returns a specific number of characters from a text string starting at the position you specify	`MID(text, start_num, num_chars)`
Not started	NUMBERVALUE (2013)	Converts text to number in a locale-independent manner
Not started	PHONETIC	Extracts the phonetic (furigana) characters from a text string
Not started	PROPER	Capitalizes the first letter in each word of a text value	`PROPER(text)`
Not started	REGEXEXTRACT (Microsoft 365)	Extracts strings within the provided text that matches the pattern
Not started	REGEXREPLACE (Microsoft 365)	Replaces strings within the provided text that matches the pattern with replacement
Not started	REGEXTEST (Microsoft 365)	Determines whether any part of text matches the pattern
Not started	REPLACE, REPLACEB	Replace Function : Replaces characters within text	`REPLACE(old_text, start_num, num_chars, new_text)`
Not started	REPT	Repeats text a given number of times	`REPT(text, number_times)`
Not started	RIGHT, RIGHTB	Returns the rightmost characters from a text value	`RIGHT(text,[num_chars])`
Not started	SEARCH, SEARCHB	Finds one text value within another (not case-sensitive)
Not started	SUBSTITUTE	Substitutes new text for old text in a text string
Not started	T	Converts its arguments to text
Not started	TEXT	Formats a number and converts it to text	`TEXT(Value you want to format, "Format code you want to apply")`
Not started	TEXTAFTER (2024)	Returns text that occurs after given character or string
Not started	TEXTBEFORE (2024)	Returns text that occurs before a given character or string
Not started	TEXTJOIN (2019)	Text: Combines the text from multiple ranges and/or strings
Not started	TEXTSPLIT (2024)	Splits text strings by using column and row delimiters
Not started	TRANSLATE (Microsoft 365)	Translates a text from one language to another
Not started	TRIM	Removes spaces from text	`TRIM(text)`
Not started	UNICHAR (2013)	Returns the Unicode character that is references by the given numeric value
Not started	UNICODE (2013)	Returns the number (code point) that corresponds to the first character of the text
Not started	UPPER	Converts text to uppercase	`UPPER(text)`
Not started	VALUE	Converts a text argument to a number	`VALUE(text)`
Not started	VALUETOTEXT (2021)	Returns text from any specified value

Text Functions

Untitled