Text
Making a label all lowercase
Definition
Turning a label into lowercase means giving LOWER the cell that holds the label.
Syntax
=LOWER(text)
Arguments
| Argument | Meaning |
|---|---|
text |
The cell that holds the label to convert. |
Worked example
A form list keeps codes in B2:B4 that must be stored in small letters.
| A: Form | B: Code |
|---|---|
| 1 | SKU |
| 2 | BIN |
| 3 | LOT |
Formula: =LOWER(B2)
Result: sku. Every letter in SKU becomes a small letter.
Practice
Cell A2 holds QTY. In B2, write a formula that converts that label to lowercase.
- In B2, write a LOWER formula for A2.
- B2 should show A2 in lowercase.
Step 1 of 2
Enter =LOWER(A2) in B2.
A2 is QTY, so lowercase is qty.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
B2 uses LOWER.
B2 now shows qty.
The next lesson is Flipping a true or false test.
Related functions
LOWER is the function that turns the label into small letters.
Common mistake
Leaving the quotes off a typed code, as in =LOWER(SKU): Excel looks for a name called SKU instead of converting the letters in B2.