LOWER, UPPER and PROPER Functions

The LOWER, UPPER, and PROPER functions in Excel are powerful tools for text manipulation. They help format text data by converting text to lowercase, uppercase, or proper case. This article will provide syntax, examples, exercises, and solutions to help you understand these functions.

Syntax

FunctionDescriptionSyntax
LOWERConverts all uppercase letters in a text string to lowercase.LOWER(text)
UPPERConverts all lowercase letters in a text string to uppercase.UPPER(text)
PROPERCapitalizes the first letter of each word in a text string.PROPER(text)

Each function takes a single argument, text, which is the text string you want to convert. The result is a new text string in the desired case format.

Example

The following example demonstrates the use of the LOWER, UPPER, and PROPER functions:

Original TextLOWERUPPERPROPER
Excel Functions=LOWER("Excel Functions")=UPPER("Excel Functions")=PROPER("Excel Functions")
automation=LOWER("automation")=UPPER("automation")=PROPER("automation")

In this example, the functions convert the original text to the specified case format.

Practice Exercise 1

Task: Convert the following text strings to lowercase, uppercase, and proper case using the appropriate functions.

Practice Exercise 2

Task: Use the LOWER, UPPER, and PROPER functions to convert the provided product names to the respective cases.

Solution for Exercise 1

Applying the functions to the original text:

Original TextLOWERUPPERPROPER
LeARning ExcEL=LOWER(A2)=UPPER(A2)=PROPER(A2)
EXCEL Is FUn=LOWER(A3)=UPPER(A3)=PROPER(A3)

The formulas convert the text to lowercase, uppercase, and proper case respectively.

Solution for Exercise 2

Converting the product names:

Original Product NameLOWERUPPERPROPER
TEXt BOOK=LOWER(A2)=UPPER(A2)=PROPER(A2)
laPtop Computer=LOWER(A3")=UPPER(A3)=PROPER(A3)

The results show the respective text conversions for each product name.

Conclusion

The LOWER, UPPER, and PROPER functions in Excel are essential for text manipulation. They allow you to standardize the text format, making data more consistent and easier to read. Practice these functions to become proficient in handling text data effectively.