How to text convert to UPPERCASE,lowercase and Proper Excel Tutorial video
1. UPPER
Purpose: Converts all letters in a text string to uppercase.
2. LOWER
Purpose: Converts all letters in a text string to lowercase.
3. PROPER
Purpose: Capitalizes the first letter of each word in a text string and converts all other letters to lowercase.