How do I change case in Excel 2010?

Answer 1

There are three case functions. Select the cell to the right of the cell you want to change case. Assume the value you want to change is in cell A2. In cell B2, type =UPPER(A2) and press <enter>. The UPPER function will convert all letters to upper case. The LOWER() function will convert to all lower case, and the PROPER() function will convert all characters to proper case where the first words are capitalized.