Sometimes it may be necessary to change the case of certain text in an Excel Worksheet. This can be changed to all lower case, all upper case and proper case with the first letter capitalized. In this example we will take data entered into a worksheet by multiple individuals that is in different cases and covert the text into the same case. This works in Excel 2010, Excel 2007, Excel 2003. The formula will work the same for all cases, you will just need to use one of the following: =LOWER =UPPER =PROPER