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.
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. 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 press “7” and then choose an option, such as “S” for Sentence case, “l” (a lowercase L) for lowercase, “U” for UPPERCASE, “C” for Capitalize Each Word, or “t” for tOGGLE cASE.Then double click on the right bottom corner of the square. If you want to use your keyboard to change the case on some text, select the text and then press Alt+H to activate the Home tab. RELATED: How to Disable Automatic Capitalization Correction in Microsoft Word The selected text changes to the selected capitalization type. You can highlight the affected text and use the tOGGLE cASE option to correct the capitalization.įor our example, we’re going to make the selected text all caps, or UPPERCASE. Toggle Case may seem like a strange option, but it’s useful if you’ve been typing text without realizing the Caps Lock key is on and the autocorrect option for correcting accidental usage of Caps Lock key is not on. tOGGLE cASE: This makes the first letter of every word lowercase and the rest of the letters UPPERCASE.Capitalize Each Word: Capitalizes the first letter of every word.UPPERCASE: Makes every letter UPPERCASE.lowercase: Makes every letter lowercase.Sentence case: Capitalizes the first letter of the first word in a sentence.The following types of capitalization are available: Select the desired type of capitalization from the drop-down menu. Then, click the “Change Case” button on the Home tab. To change the case on text in a Word document, select the text you want to change and make sure the Home tab is active. Did you type a line of text and then realize that it should have been capitalized differently? Instead of typing the line again, you can quickly and easily change the case of any text in Word without retyping it.