Text Functions

ARRAYTOTEXT	(2024) The contents of an array or cell range converted to text.
ASC	(Japanese) The text string converted from double byte to single byte characters.
BAHTTEXT	The number converted to Thai text and appended with 'Baht'.
CHAR	The character with the corresponding ANSI/ASCII number.
CLEAN	The text string with all the non-printable characters removed.
CODE	The ANSI/ASCII number for the first character in a text string.
CONCAT	(2019) The text string that is a concatenation of cell ranges and strings.
CONCATENATE	(CONCAT) The text string that is a concatenation of several strings.
DBCS	(Japanese) The text string converted from single byte to double byte characters.
DOLLAR	The text string of a number with the dollar formatting $0,000.00.
EXACT	The value True or False based on whether two strings match exactly.
FIND	The starting position of a substring within a larger text string (case sensitive).
FIXED	The text string of a number rounded to a fixed number of decimal places.
JIS	(Japanese) The text string converted from single byte to double byte characters (renamed).
LEFT	The first or left most characters in a text string.
LEN	The number of characters in a text string.
LOWER	The text string with all the characters converted to lowercase.
MID	The characters from the middle of a text string.
NUMBERVALUE	The number that a text string represents (current locale).
PHONETIC	The phonetic characters from a text string.
PROPER	The text string with the first letter of every word as a capital letter.
REGEXEXTRACT	(365) Preview. The characters that match a regular expression.
REGEXREPLACE	(365) Preview. The text string after replacing characters that match a regular expression.
REGEXTEST	(365) Preview. The boolean True or False depending if the regular expression matches any part of a text string.
REPLACE	The text string after replacing characters in a specific location.
REPT	The text string repeated a number of times.
RIGHT	The last or right most characters in a text string.
SEARCH	The starting position of a substring within a larger text string (not case sensitive).
SUBSTITUTE	The text string after replacing instances of a substring.
T	The text string of the value given.
TEXT	The number as a formatted text string.
TEXTAFTER	(2024) The characters from the end of a text string after a delimiter.
TEXTBEFORE	(2024) The characters from the start of a text string before a delimiter.
TEXTJOIN	(2019) The text string that is a concatenation of several strings with a delimiter.
TEXTSPLIT	(2024) The text string split into multiple columns using delimiters.
TRANSLATE	(365) Preview. The text string translated into another language.
TRIM	The text string with all extra spaces removed from the beginning, middle and end.
UNICHAR	The character with the corresponding UNICODE character.
UNICODE	The unicode number for the first character in a text string.
UPPER	The text string with all the characters converted to uppercase.
VALUE	(NUMBERVALUE) The number that a text string represents (renamed).
VALUETOTEXT	(2024) The value converted to text.

ARRAYTOTEXT (2024) The contents of an array or cell range converted to text.
ASC (Japanese) The text string converted from double byte to single byte characters.
BAHTTEXT The number converted to Thai text and appended with 'Baht'.
CHAR The character with the corresponding ANSI/ASCII number.
CLEAN The text string with all the non-printable characters removed.
CODE The ANSI/ASCII number for the first character in a text string.
CONCAT (2019) The text string that is a concatenation of cell ranges and strings.
CONCATENATE (CONCAT) The text string that is a concatenation of several strings.
DBCS (Japanese) The text string converted from single byte to double byte characters.
DOLLAR The text string of a number with the dollar formatting $0,000.00.
EXACT The value True or False based on whether two strings match exactly.
FIND The starting position of a substring within a larger text string (case sensitive).
FIXED The text string of a number rounded to a fixed number of decimal places.
JIS (Japanese) The text string converted from single byte to double byte characters (renamed).
LEFT The first or left most characters in a text string.
LEN The number of characters in a text string.
LOWER The text string with all the characters converted to lowercase.
MID The characters from the middle of a text string.
NUMBERVALUE The number that a text string represents (current locale).
PHONETIC The phonetic characters from a text string.
PROPER The text string with the first letter of every word as a capital letter.
REGEXEXTRACT (365) Preview. The characters that match a regular expression.
REGEXREPLACE (365) Preview. The text string after replacing characters that match a regular expression.
REGEXTEST (365) Preview. The boolean True or False depending if the regular expression matches any part of a text string.
REPLACE The text string after replacing characters in a specific location.
REPT The text string repeated a number of times.
RIGHT The last or right most characters in a text string.
SEARCH The starting position of a substring within a larger text string (not case sensitive).
SUBSTITUTE The text string after replacing instances of a substring.
T The text string of the value given.
TEXT The number as a formatted text string.
TEXTAFTER (2024) The characters from the end of a text string after a delimiter.
TEXTBEFORE (2024) The characters from the start of a text string before a delimiter.
TEXTJOIN (2019) The text string that is a concatenation of several strings with a delimiter.
TEXTSPLIT (2024) The text string split into multiple columns using delimiters.
TRANSLATE (365) Preview. The text string translated into another language.
TRIM The text string with all extra spaces removed from the beginning, middle and end.
UNICHAR The character with the corresponding UNICODE character.
UNICODE The unicode number for the first character in a text string.
UPPER The text string with all the characters converted to uppercase.
VALUE (NUMBERVALUE) The number that a text string represents (renamed).
VALUETOTEXT (2024) The value converted to text.