ARRAYTOTEXT
ARRAYTOTEXT(array, [format])
ASC
ASC(text)
BAHTTEXT
BAHTTEXT(number)
CHAR
CHAR(number)
CLEAN
CLEAN(text)
CODE
CODE(text)
CONCAT
CONCAT(text1, [text2], ...)
CONCATENATE
CONCATENATE(text1, [text2], ...)
DBCS
DBCS(text)
DETECTLANGUAGE
DETECTLANGUAGE(text)
DOLLAR
DOLLAR(number, [decimals])
EXACT
EXACT(text1, text2)
FIND
FIND(find_text, within_text, [start_num])
FINDB
FINDB(find_text, within_text, [start_num])
FIXED
FIXED(number, [decimals], [no_commas])
JIS
JIS(text)
LEFT
LEFT(text, [num_chars])
LEFTB
LEFTB(text, [num_bytes])
LEN
LEN(text)
LENB
LENB(text)
LOWER
LOWER(text)
MID
MID(text, start_num, num_chars)
MIDB
MIDB(text, start_num, num_bytes)
NUMBERVALUE
NUMBERVALUE(text, [decimal_separator], [group_separator])
PHONETIC
PHONETIC(reference)
PROPER
PROPER(text)
REGEXEXTRACT
REGEXEXTRACT(text, pattern, [return_mode], ...)
REGEXREPLACE
REGEXREPLACE(text, pattern, replacement, ...)
REGEXTEST
REGEXTEST(text, pattern, [case_sensitivity])
REPLACE
REPLACE(old_text, start_num, num_chars, new_text)
REPLACEB
REPLACEB(old_text, start_num, num_bytes, new_text)
REPT
REPT(text, number_times)
RIGHT
RIGHT(text, [num_chars])
RIGHTB
RIGHTB(text, [num_bytes])
SEARCH
SEARCH(find_text, within_text, [start_num])
SEARCHB
SEARCHB(find_text, within_text, [start_num])
SUBSTITUTE
SUBSTITUTE(text, old_text, new_text, [instance_num])
T
T(value)
TEXT
TEXT(value, format_text)
TEXTAFTER
TEXTAFTER(text, delimiter, [instance_num], ...)
TEXTBEFORE
TEXTBEFORE(text, delimiter, [instance_num], ...)
TEXTJOIN
TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
TEXTSPLIT
TEXTSPLIT(text, col_delimiter, [row_delimiter], ...)
TRANSLATE
TRANSLATE(text, [source_language], [target_language])
TRIM
TRIM(text)
UNICHAR
UNICHAR(number)
UNICODE
UNICODE(text)
UPPER
UPPER(text)
VALUE
VALUE(text)
VALUETOTEXT
VALUETOTEXT(value, [format])
Text
Text functions help to manipulate and analyze text strings.