UPPER Function
Purpose
Converts all lowercase letters in a text string to uppercase.
Syntax
EXCEL
=UPPER(text)
Arguments Breakdown
| Argument | Required? | Description |
|---|---|---|
text |
Required | The text you want converted to uppercase. Can be a reference or text string. |
Practical Examples
1. Uppercase Conversion Drill
From Formulas_&_Functions_Part_1.xlsx:
If A1 contains "Mostafa":
EXCEL
=UPPER(A1)
Result: "MOSTAFA".
2. Standardization for Key Joins
Ensuring foreign keys or state abbreviations are consistent before matching:
EXCEL
=UPPER(TRIM(Customer[State]))
Related Knowledge
- Notes: 05 Text Manipulation Functions
- Workbook:
11_Demos_and_Workbooks/03_Formulas_and_Functions/Formulas_&_Functions_Part_1.xlsx(Sheet:Text)