Change Case using UPPER, LOWER and PROPER Function

In excel there are three different cases available as follows.

=PROPER() capitalizes the first letter of each word (like Title Case)

= UPPER() – forces all letters to be UPPERCASE

= LOWER() – forces all letters to be lower case

Tip: If you are looking for online case converter, then visit this case converter site to convert case.

Examples:

1. Convert text in lowercase to UPPERCASE using function UPPER()

converting-to-upper-case-in-excel

2. Convert text in UPPERCASE to lowercase using function LOWER()

converting-upper-case-to-lower-case-in-excel

3. Convert text into Proper Case(Sentence Case) using function PROPER()

converting-to-propercase-in-excel

Click Here to Leave a Comment Below 0 comments

Leave a Reply: