On this page, you'll find the most commonly used text functions, each demonstrated in a simple example.
|CONCATENATE||Join values, one after another|
|LEFT||Extract characters starting from the left|
|LOWER||Convert to lowercase|
|MID||Extract characters from a string|
|PROPER||Convert the first letter of each word to uppercase and the other letters to lowercase|
|RIGHT||Extract characters starting from the right|
|UPPER||Convert to uppercase|