Convert the case of text (Upper, Lower or Proper) in Excel

If you want to convert text from uppercase to lowercase or from lowercase to proper case to make it more readable. To change the case of text, you can use the UPPER, LOWER, or PROPER functions as shown below:

1. Let say cell A1 contains "suneel gudipati"
2. To convert the text into upper case enter the formula =UPPER(A1)
3. It changes text to all Upper case as "SUNEEL GUDIPATI"
4. Similarly to convert into lower case enter the formula =LOWER(A1)
5. It changes text to all lowercase as "suneel gudipati"
6. Similarly to convert into Title case enter the formula =PROPER(A1)
7. It changes text to all lowercase as "Suneel Gudipati"