

The below text is an improper text which is needed to convert to proper case. Now let us take an example of a proper case function. The result is “magazine”, as shown below. The word “MAGAZINE” is in the upper case. Let us take another example where we need to convert texts into a lower case. The result is “REPUTATION”, which is an upper case word now. Some cases/illustrations where use sentence case works are as follows: Below are the steps to convert such sentences into the proper case.

But after one sentence, we can drag the cursor downwards and convert all sentences to proper case. But what if a sentence needs to be converted into a required format with lower, upper and mixed case words. A single word can be converted with one function only, either lower(), upper() or proper(). Microsoft Word has a built-in button to convert the text into the required format, but Excel doesn’t have the same. For example, the word “pRoDucT” is converted to “Product”.
