You can instead enter the text directly into the function. Note that you don’t need to include cell references within those functions.Thus, the PROPER function capitalizes each word in the text string. That will convert the text in C2 to Tech Junkie in D2 as shown below. Next, select cell D2, input ‘ =PROPER(C2)‘ in the function bar, and then press the Enter key.This will convert the text in B2, TECH JUNKIE, to lowercase, as shown below. Now, click cell C2, type ‘ =LOWER(B2)‘ in the fx bar and press the Enter key.That will convert the text in A2 to TECH JUNKIE in cell B2 as shown directly below. Then, select cell B2, and enter ‘ =UPPER(A2)‘ in the fx bar.To get an idea of how you can add these functions to cells, open a blank Excel spreadsheet and type ‘ tech junkie‘ in cell A2. ![]() UPPER converts the text to uppercase, LOWER converts it to lowercase and PROPER capitalizes the first letter of each word in a cell. ![]() The functions that change case are UPPER, LOWER, and PROPER. We’ll cover these in detail in this article How to Change Case in ExcelĮxcel has three main functions that you can adjust text case in cells with. However, Excel also includes a few functions that you can adjust the text case with.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |