skip to Main Content

How to Change the Case of Text in a Worksheet (Excel 2010/2007/2003)

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
This post is only available to members.
Read More
Back To Top