![change case in word shortcut key change case in word shortcut key](https://www.tutorialspoint.com/word/images/toggle_case.jpg)
Now, the “PHONE” word is converted to “phone”. Let us apply the lower function as below to convert the first text to a lower case.Ī1 in lower(A1) signifies that the A1 cell’s text is to be converted into lower case. Below is the data in Excel, which are mixed and unorganized. Not only the upper case, any improper or mixed text can also be converted into lower case. Below is the text, which is in the upper case, which we need to convert into lower case. Alternatively, we can drag the cursor from B1 to B5 to automatically convert the texts into the upper case. Similarly, other cells can be converted into upper case. A1 is the parameter which implies that we were changing the text case of the A1 cell, and the result is shown in the B1 cell. For that, we’ll use the upper case function mentioned below.Īfter applying the upper(A1), “India” is converted to “INDIA” as below, where all letters are in the upper case. We need to convert these texts into upper case. Below is the excel data which is not properly entered. We have entered a text in an Excel worksheet. Let us understand clearly about these functions. There are three functions to convert the text in Excel. The output is “Imagine”, where the first letter is in the upper case, and the rest are in the lower case. 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.
![change case in word shortcut key change case in word shortcut key](https://www.top-password.com/blog/wp-content/uploads/2018/09/drag-the-formula-cell.png)
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”. Proper(): Proper function converts the text into a proper case from a mixed or improper text.Lower(): Lower function converts the text into a lower case from any other case.Upper(): Upper function converts the text into an upper case from any other case.There are three types of functions in sentence case as described below: Excel functions, formula, charts, formatting creating excel dashboard & others