How to change case in MS Excel

Change Case in MS Excel using Formula
Lets continue with Excel tips & tricks.
#15: Sentence Case
In Excel, we have three different functions (LOWER, UPPER, and PROPER) to convert a text into different cases.
But there is no option to convert a text into sentences case.
Here is the formula which you can use:
=UPPER(LEFT(B7,1))&LOWER(RIGHT(B7,LEN(B7)-1))
This formula converts the first letter of a sentence into capital and rest of all in small…
How this formula works? Keep in touch for further uploads.
#HappyLearning!
Music Credit: bensound.com