In Microsoft Excel, Upper and Lower functions are Text functions. The Lower function’s purpose is to convert text into lowercase, and the Upper function converts text to uppercase.

Excel doesn't offer a one-click solution if you need text in sentence case (where only the first letter of the sentence is capitalized). But don’t worry! You can create a custom formula using the LEFT ...