PROPER function – capitalizes the first letter in each word.
UPPER function – changes text to uppercase.
LOWER function – changes text to lowercase.
Highlights
- Understand the key syntax of basic text functions
- Create functions to alter the case of text
- Paste the result values of formulas removing the formula