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:

  1. Click to highlight the cell that contains the text.
  2. Select the "Formulas" tab > Select the "Text" drop-down list in the "Function Library" group.
  3. Select "LOWER" for lowercase and "UPPER" for uppercase.

Keywords: lower case, change words, no caps, all caps, office 2010

Help Page Feedback

Did this content help you? *


What is your opinion about the content? *


Suggest new content or let us know how we can improve this content (optional):

If you desire a response, please provide your email address (optional):

Leave this field empty