How to Change Text Case in Microsoft Excel 2019-2010 easily
This post is about how to Change Text Case in Microsoft Excel 2019-2010 easily. In this article will show you how to use the UPPER, LOWER, or RIGHT CASE functions to change the current text to uppercase, lowercase, or appropriate case.
Convert text files to Excel
The easiest way to change from lowercase to uppercase in Excel is to use the UPPER function. Alternatively, use the LOWER function to convert all characters in a text string to lowercase. The appropriate function is used to convert the text to a proper font, which capitalizes the first letter of each word.
How to change a text into a proper sentence
Insert a temporary column next to the column containing the text you want to translate if necessary.
Enter the proper function
In cell B1, type =PROPER(A1), and then press Enter. Enter the appropriate service
This formula converts the names in cell A1 from uppercase to lowercase.
To change the text to lower, type =LOWER(A1) instead.
Use =UPPER(A1) in cases where you want to convert the text to uppercase, replacing A1 with the appropriate cell comparison.
Using Flash Fill
Fill in the new row and column.
The easiest way to do this is to select cell B1 and double click on the small black space that appears in the lower right corner of the cell.