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:
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.
Music Credit: bensound.com