Reverse Case of Text
When importing data from another source, often times the data is displayed in all uppercase or all lowercase text. If you want to change the case, follow these instructions for Office 2007 and 2010:
- Click to highlight the cell that contains the text.
- Select the "Formulas" tab > Select the "Text" drop-down list in the "Function Library" group.
- Select "LOWER" for lowercase and "UPPER" for uppercase.
Keywords: lower case, change words, no caps, all caps, office 2010