Below is the list of 30 text functions:
| Function | Formula |
|---|---|
| CHAR Function | Char(Num) |
| CLEAN Function | Clean(Text) |
| CODE Function | Code(Text) |
| CONCATENATE Function | Concatenate (Cell 1, Cell 2…) |
| DOLLAR Function | Dollar(Num, [Decimals]) |
| EXACT Function | Exact(Text1, Text2) |
| FIND Function | Find(Find_Text, Within_Text, [Start_Num]) |
| FINDB Function | Findb(Find_Text, Within_Text, [Start_Num]) |
| FIXED Function | Fixed(Num, [Decimals], [No_Commas]) |
| LEFT Function | Left(Text, [Num_Chars]) |
| LEFTB Function | Leftb(Text, [Num_Chars]) |
| LEN Function | Len(Text) |
| LENB Function | Lenb(Text) |
| LOWER Function | Lower(Text) |
| MID Function | Mid(Text, Start_Num, Num_Chars) |
| MIDB Function | Midb(Text, Start_Num, Num_Bytes) |
| PROPER Function | Proper(Text) |
| REPLACE Function | Replace(Old_Text, Start_Num, Num_Chars, New_Text) |
| REPLACEB Function | Replaceb(Old_Text, Start_Num, Num_Bytes, New_Text) |
| REPT Function | Rept(Text, Num_Times) |
| RIGHT Function | Right(Text,[Num_Chars]) |
| RIGHTB Function | Rightb(Text,[Num_Bytes]) |
| SEARCH Function | Search(Find_Text,Within_Text,[Start_Num]) |
| SEARCHB Function | Searchb(Find_Text,Within_Text,[Start_Num]) |
| SUBSTITUTE Function | Substitute(Text, Old, New, [Instance_Num]) |
| T Function | T(Text) |
| TEXT Function | Text(Value, Format_Text) |
| TRIM Function | Trim(Text) |
| UPPER Function | Upper(Text) |
| VALUE Function | Value(Text) |