![how to change case in word shorcut how to change case in word shorcut](https://easykey.uk/images/help/excel/excel-insert.jpg)
Now we will see how it will convert if the entire text is in the upper case.Įven if all the texts are in the upper case, they will be converted in the same way. If we compare both texts, all the first letters of the word are uppercase. Observe text ‘J’ is capital in January ‘, I’ is capital in Is ‘F’ is capital in First ‘M’ is capital in Month. Now apply this to all other cells also by dragging the formula until data is available. Now select the cell address in place of text. The syntax for proper is similar as upper and lower =PROPER(text) find the below screenshot for reference. Now we will apply a proper function to these texts and will check how it converts. Because “UPPER” will convert everything to upper case and “LOWER” will convert everything to lower case, but “PROPER” will convert every first letter of the word to upper case and the remaining into lowercase.Ĭonsider the below text, which is in a mixed-format some letters are in the upper case and some lowercase letters. One more function is available to convert from one case to another case, but it is quite different from upper and lower functions. Example #3 – Change any case to a Proper case We have one more function called proper, which we have to discuss.
#How to change case in word shorcut how to
With this, we covered how to convert data a lower-case text to upper case and upper-case text to lower case. Then apply this to all other cells by dragging the formula until data is available.Īs the text is converted to lower case, copy text and paste the data as similar to how we did in the upper case and delete the formula cells. In place of text, we will input the Cell Address of text that we want to convert to lower. Observe the below screenshot for reference. The syntax of lower is also similar to upper that is =LOWER(Text). Now we will convert the same months to lower case.
![how to change case in word shorcut how to change case in word shorcut](https://digiruns.com/wp-content/uploads/2019/02/Changing-sentence-case-in-ms-word.png)
This is also quite similar to the upper case function still we will see one example of how to convert to lower case.Ĭonsider the example which we already converted to upper case. Now we will see how to convert an upper-case text into lower case text. Up to now, we have seen how to convert small case to upper case. Then click on OK.Īfter deleting the column with formulas, we will get results as shown below. So, copy the data that is converted in uppercase and select cell A1 and right click then, the below pop up menu will appear.Ĭhoose the Paste Special option and select Values. Now data is converted to Upper case, but it is not in the required place of a spreadsheet. Then double click on the right bottom corner of the square.