How to change case in Excel sheet?
Changing case in Excel seems to be not as easy as in Word files. The MS users try to find various methods to complete the task. However, it can be easier with a new feature added to ONLYOFFICE spreadsheet editor. Read this article to know how to change case in Excel sheets.
Changing the case or capitalization in Excel can help bring the data in the cells into the same look. Since there is no function similar to Word, users follow several more complicated ways to do this:
- Change the letters manually. The most obvious and at the same time the longest way is to change the letter case manually using the Shift key.
- Use document editor functionality. You can copy the data you want to change the case of in the text editor and use the automatic function, and then add the data back to the table.
- Add formulas. Formulas in Excel can replace this case-changing function, but require some additional knowledge. Let’s look at how to use the formulas below.
In addition to the methods listed above, there is probably the easiest way to change the case in Excel using the ONLYOFFICE spreadsheet editor.
How to change case in Excel sheet with ONLYOFFICE
Starting with version 7.4, the ONLYOFFICE spreadsheet editor gets the case change feature. This function serves as a full analog of the one in Word and makes it much easier to work with capitalization and changing the case of letters in cells.
The feature is available on the Home tab on the top toolbar.
You can select one of the options from the drop-down list: Sentence case., lowercase, UPPERCASE, Capitalize Each Word, and tOOGLE cASE. Let’s look at each option in detail.
How to capitalize the first letter of a sentence in Excel sheets?
To capitalize only the first letter of the sentence, use Sentence case. It capitalizes only the first letter of your phrase in the cell.
To do it, choose the cell or a group of cells where you want to capitalize the first letters. Then, click the Change case button and choose Sentence case.
Alternatively, you can make the same using the Excel formula.
First of all, you need to insert an additional column where the results will appear. In our example, the column will be inserted between the columns Month and Quantity. Open the context menu by right-clicking any cell in the Quantity column.
In the context menu find Insert —> Column Left.
Then, put the cursor into a cell in a new column and enter the following formula:
=REPLACE(LOWER(E2),1,1,UPPER(LEFT(E2,1)))
where E2 is any cell with the phrase you want to capitalize the first letter in.
Do the same with the rest of the rows by dragging the little plus in the bottom right corner of the cell with the formula.
How to make all the letters lowercase in Excel sheets?
To make all letters lowercase, use the appropriate option in the Change Case menu.
To make letters lowercase with a formula, use the LOWER function. It is used to convert uppercase letters to lowercase in the selected cell.
Select the cell where you wish to display the result or insert a new one as described above. Then, go to the Formula tab at the top toolbar —> Text and data —> LOWER function.
Enter the required argument in the appeared window. Click the OK button.
How to capitalize all the letters?
Capitalized text in a table can be used to highlight the main point, draw attention, or improve the readability of the data in the table. If this is the case for you, use the UPPERCASE option in the dropdown list.
If you need to capitalize all letters in the selected cell using a formula, choose the UPPER function in the Text and data group. Follow the same step described above to insert it.
How to capitalize the first letter of each word?
Capitalizing the first letter of each word can make sense when you have names on your sheet. The easiest way to make sure they are all written correctly is to use Capitalize Each Word option.
Define cell range with names and go to the Home Tab —> Change Case button —> Capitalize Each Word.
As for the formula, use the PROPER function. It is used to convert the first character of each word to uppercase and all the remaining characters to lowercase.
Work on your spreadsheets with ONLYOFFICE
Try the functionality of the ONLYOFFICE spreadsheet editor to create and manage your data in tables. You can download free desktop editors for Windows, Linux, or macOS or store and edit your files in the cloud with ONLYOFFICE DocSpace:
