Change Text Case with the help of Formulas – Upper, Lower & Proper

Change Text Case from Upper Case to Lower and Vice Versa:

It is very quick in Excel to change text case with the help of Formulas. One can switch from upper case to Lower or Lower to Upper or even change the Text case on any cell to desired format.

Example on Change Text Case:

Change Text Case

Example: Upper, Lower and Proper

 

Formula to switch to Upper Case:

Upper: It can be used to convert the text case of any cell in Upper Case (Capital Letters). For E.g., In Cell A1 we have “Learn excel”. Now put Upper formula in Cell A2. For E.g., =Upper(A1). It will convert the value to “LEARN EXCEL”.

Formula to switch to Lower Case:

Lower: It can be used to convert the text case of any cell in Lower Case (Small Letters). For E.g., In Cell A1 we have “Learn excel”. Now put Lower formula in Cell A3. For E.g., =Lower(A1). It will convert the value to “learn excel”. Please make a note that it has changed “Learn excel” to “learn excel” where L in “Learn” has been changed to l in Lower Case “Small Letters”.

Formula to switch to Proper Case:

Proper: One can even switch to Proper Case where first character of each word is in capital letter and all other are in small letters. For E.g., In Cell A1 we have “Learn excel”. Now put Proper formula in Cell A4. For E.g., =Proper(A1). It will convert the value to “Learn Excel”. Please make a note that it has changed “Learn excel” to “Learn Excel” where e in “excel” has been changed to E in Upper Case “Capital Letters”.

Hope you find Change Text Case useful.

Do you need Excel Training?

Consider participating in our training programs. Please visit “Upcoming Training” section on our website.


Categories: Formulas, Tips and Tricks

Tags: , , , ,

Leave a Reply

%d bloggers like this: