How to change the case of the text using UPPER, LOWER and PROPER function?

image_pdf

In excel there are three different cases available as follows.

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

= UPPER() - forces all letters to be UPPER CASE

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

Examples:

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

UpperCase

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

lower

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

proper

1,394 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>