Below is the list of 30 text functions:

FunctionFormula
CHAR FunctionChar(Num)
CLEAN FunctionClean(Text)
CODE FunctionCode(Text)
CONCATENATE FunctionConcatenate (Cell 1, Cell 2…)
DOLLAR FunctionDollar(Num, [Decimals])
EXACT FunctionExact(Text1, Text2)
FIND FunctionFind(Find_Text, Within_Text, [Start_Num])
FINDB FunctionFindb(Find_Text, Within_Text, [Start_Num])
FIXED FunctionFixed(Num, [Decimals], [No_Commas])
LEFT FunctionLeft(Text, [Num_Chars])
LEFTB FunctionLeftb(Text, [Num_Chars])
LEN FunctionLen(Text)
LENB FunctionLenb(Text)
LOWER FunctionLower(Text)
MID FunctionMid(Text, Start_Num, Num_Chars)
MIDB FunctionMidb(Text, Start_Num, Num_Bytes)
PROPER FunctionProper(Text)
REPLACE FunctionReplace(Old_Text, Start_Num, Num_Chars, New_Text)
REPLACEB FunctionReplaceb(Old_Text, Start_Num, Num_Bytes, New_Text)
REPT FunctionRept(Text, Num_Times)
RIGHT FunctionRight(Text,[Num_Chars])
RIGHTB FunctionRightb(Text,[Num_Bytes])
SEARCH FunctionSearch(Find_Text,Within_Text,[Start_Num])
SEARCHB FunctionSearchb(Find_Text,Within_Text,[Start_Num])
SUBSTITUTE FunctionSubstitute(Text, Old, New, [Instance_Num])
T FunctionT(Text)
TEXT FunctionText(Value, Format_Text)
TRIM FunctionTrim(Text)
UPPER FunctionUpper(Text)
VALUE FunctionValue(Text)