There are 32 text functions varying in usefulness, power and potential complexity.
Text String Information Functions
Converion to Upper and Lower Case Information Functions
Joining and Slicing String Functions
Using a Text function:
Text functions help you manipulate text. Some are very simple like LEFT and RIGHT. Others, like REPLACE can be more powerful but require a little more effort to use.