Now, fill down the formula in the new column. Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference. To convert the text to lowercase, type =LOWER(A2) instead. This formula converts the name in cell A2 from uppercase to proper case. In cell B2, type =PROPER(A2), then press Enter.
In this case, we’ve added a new column (B) to the right of the Customer Name column. In the example below, the PROPER function is used to convert the uppercase names in column A to proper case, which capitalizes only the first letter in each name.įirst, insert a temporary column next to the column that contains the text you want to convert. Functions are just built-in formulas that are designed to accomplish specific tasks-in this case, converting text case. However, you can use the UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case. Unlike Microsoft Word, Microsoft Excel doesn't have a Change Case button for changing capitalization.
0 kommentar(er)
