The UPPER, LOWER, and PROPER functions are text formatting functions used to change the case (capitalization) of text in Excel. These functions are very useful for cleaning and standardizing data.
1. UPPER Function
The UPPER function converts all letters in a text string to uppercase.
Structure:
=UPPER(text)
Example:
If cell A1 contains:
ali khan
Formula:
=UPPER(A1)
Result:
ALI KHAN
2. LOWER Function
The LOWER function converts all letters in a text string to lowercase.
Structure:
=LOWER(text)
Example:
If cell A1 contains:
ALI KHAN
Formula:
=LOWER(A1)
Result:
ali khan
3. PROPER Function
The PROPER function converts text to proper case.
- First letter of each word → Capital
- Remaining letters → Lowercase
Structure:
=PROPER(text)
Example:
If cell A1 contains:
ali khan
Formula:
=PROPER(A1)
Result:
Ali Khan
Practical Example
If A1 contains:
gIGz.pk free TRAINING
- =UPPER(A1) → GIGZ.PK FREE TRAINING
- =LOWER(A1) → gigz.pk free training
- =PROPER(A1) → Gigz.Pk Free Training
Why These Functions Are Important
They help you:
- Clean imported data
- Standardize names and titles
- Correct inconsistent capitalization
- Prepare professional reports
- Improve data presentation
Important Notes
- These functions only change text appearance, not formatting.
- Numbers and symbols remain unchanged.
- Useful when working with names, emails, and addresses.
UPPER, LOWER, and PROPER are simple but powerful tools for managing and formatting text data efficiently in Excel.