How to use PROPER, UPPER and LOWER Function | Microsoft Excel

PROPER Function

PROPER Function is used to Capitalize the first letter of the word and remaining letters are converted into lowercase. PROPER Function simplifies the editing of text

Syntax of PROPER Function

=PROPER(text)

Arguments for PROPER Function

text: the text which you want to convert in a proper way

Behavior of PROPER Function

Here we have taken an example of irregular text and you can see after using PROPER Function the text are looks regular

Here

mahaTma gaNDhi Becomes Mahatma Gandhi after using PROPER Function

SARDAR PATEL Becomes Sardar Patel after using PROPER Function

manmohan singh Becomes Manmohan Singh after using PROPER Function

Usage of PROPER Function

To capitalize each letter of the word

Return of PROPER Function

Regularized text

_________________________________

UPPER Function

UPPER Function is used to convert text to upper case. 

Syntax for UPPER Function

=UPPER(text)

Arguments for UPPER Function

text: this is the text which you want to convert into UPPER case

Behaviour of UPPER Function

Here we have taken the example of three names which is not regularised text. UPPER Function will convert this ir-regularised text into UPPER case

mahaTma gaNDhi Becomes MAHATMA GANDHI after using UPPER Function

SarDar patEL Becomes SARDAR PATEL after using UPPER Function

manMOHAN sinGH Becomes MANMOHAN SINGH after using UPPER Function

Usage of UPPER Function

To convert text into UPPER case

Return  of UPPER Function

UPPER Function will return the same text into UPPER case

_________________________________

LOWER Function

LOWER Function is used to convert text to lower case. 

Syntax for LOWER Function

=LOWER(text)

Arguments for LOWER Function

text: this is the text which you want to convert into LOWER case

Behaviour of LOWER Function

Here we have taken the example of three names which is not regularised text.LOWER Function will convert this not regularised text into LOWER case

mahaTma gaNDhi Becomes "mahatma gandhi" after using LOWER Function

SarDar patEL Becomes "sardar patel" after using LOWER Function

manMOHAN sinGH Becomes "manmohan singh" after using LOWER Function

Usage of LOWER Function

To convert text into LOWER case

Return  of LOWER Function

LOWER Function will return the same text into LOWER case