How many ways you can change case in Ms Excel ?

Generally, excel have three options, they are 1. Upper, 2. Lower and 3. Proper

You can have following three cases in MS Excel:

• LOWER (Formula = LOWER("Text" | Cell Reference) for converting any text to All Lower Case.

• UPPER (Formula = UPPER("Text" | Cell Reference) for converting any text to All Upper Case.

• PROPER (Formula = PROPER("Text" | Cell Reference) for converting any text to all Proper Case.

check :

https://www.ablebits.com/office-addins-blog/2014/04/25/change-case-excel-uppercase-lowercase/