PROPER , UPPER and LOWER function in Excel

For text formatting in excel we can use PROPER , UPPER and LOWER function .

PROPER function – capitalizes the first letter in each word.

UPPER function – changes text to all uppercase.

LOWER function – changes text to all lowercase.


Example: LOWER function – changes text to all lowercase.

Example: PROPER function – capitalizes the first letter in each word.

Example: UPPER function – changes text to all uppercase.