### 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

=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.

=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.

=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