There are 32 text functions varying in usefulness, power and potential complexity.

Text String Information Functions

Function Usefulness Power Complexity
EXACT
FIND
FINDB
LEN
LENB
MIDB
REPLACE
REPLACEB
SEARCH
SEARCHB
T

Converion to Upper and Lower Case Information Functions

Function Usefulness Power Complexity
LOWER
PROPER
UPPER

Joining and Slicing String Functions

Function Usefulness Power Complexity
CLEAN
CONCATENATE
LEFT
LEFTB
MID
REPT
RIGHT
RIGHTB
SUBSTITUTE
TRIM

String Conversion Functions

Function Usefulness Power Complexity
ASC
CHAR
CODE

Data Type Conversion Functions

Function Usefulness Power Complexity
BAHTTEXT
DOLLAR
FIXED
TEXT
VALUE
#1)
Using a Text function:
Using a Text Excel function

Summary

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.