65. Using UPPER, LOWER, and PROPER for case changes
Using UPPER, LOWER, and PROPER for Case Changes
Excel provides three functions to manipulate the case of text:
- UPPER: Converts all text to uppercase (e.g., "john doe" becomes "JOHN DOE").
- LOWER: Converts all text to lowercase (e.g., "JOHN DOE" becomes "john doe").
- PROPER: Capitalizes the first letter of each word (e.g., "john doe" becomes "John Doe").
Steps to Use UPPER, LOWER, and PROPER
- Step 1: Select the cell containing the text you want to transform.
- Step 2: Enter the formula:
=UPPER(A1)
for uppercase=LOWER(A1)
for lowercase=PROPER(A1)
for proper case
- Step 3: Press Enter to apply the function.
- Step 4: Copy the transformed text to replace the original values if needed.
Interactive Example: Case Changes
# | Original Text | UPPER | LOWER | PROPER |
---|---|---|---|---|
1 | john doe | -- | -- | -- |
2 | JANE SMITH | -- | -- | -- |
3 | aLiCe JoHnSon | -- | -- | -- |
Click "Apply Case Changes" to transform the text into uppercase, lowercase, and proper case in their respective columns.
Comments
Post a Comment