LOWER Function
Purpose
Converts all uppercase letters in a text string to lowercase.
Syntax
EXCEL
=LOWER(text)
Arguments Breakdown
| Argument | Required? | Description |
|---|---|---|
text |
Required | The text you want converted to lowercase. Does not affect non-alphabetic characters. |
Practical Examples
1. Lowercase Conversion Drill
From Formulas_&_Functions_Part_1.xlsx:
If A1 contains "Mostafa":
EXCEL
=LOWER(A1)
Result: "mostafa".
2. Email Normalization
EXCEL
=LOWER(TRIM(UserEmails))
Related Knowledge
- Notes: 05 Text Manipulation Functions
- Workbook:
11_Demos_and_Workbooks/03_Formulas_and_Functions/Formulas_&_Functions_Part_1.xlsx(Sheet:Text)