Table of Contents
Using following Steps:
1. Convert to UPPERCASE:
- Use the formula: =UPPER(A1)
- Press Enter to apply.
- Drag the fill handle down to apply to more rows.
2. Convert to lowercase:
- Use the formula: =LOWER(A1)
- Press Enter and drag down to apply.
3. Convert to Proper Case (First Letter Capitalized):
- Use the formula: =PROPER(A1)
- Press Enter to apply.
This helps in formatting student names or other data properly!
