EXCEL TIPS - Functions LOWER, UPPER & PROPER

Excel TIPS on LOWER, UPPER & PROPER Functions.

FUNCTIONS LOWER, UPPER & PROPER

To change a text in Lower, Upper or Proper case, these functions are useful.

1.  LOWER

        

Converts all uppercase letters in a text string to lowercase.

=LOWER(text)

                                                                                                

Text is the text you want to convert to lower case. LOWER does not change characters that are not text.

Examples:

=LOWER(JOSEF)                  josef

=LOWER(jOSef)                   josef

2.  UPPER

Converts all letters in a text string to uppercase.

=UPPER(text)

Text is the text you want to convert to upper case. UPPER does not change characters that are not text.

Examples:

=UPPER(josef)                      JOSEF

=UPPER(Josef)                     JOSEF

3.  PROPER

Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.

=PROPER(text)

Text is the text you want to convert to proper case. PROPER does not change characters that are not text.

Examples:

=PROPER(this is a TITLE)               This is a Title

=PROPER(JOSEF)                                   Josef