How to change case in MS Excel

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