How to Reverse Case of Text in Excel

  1. Top 10 Help Pages
  2. Recent Additions
  3. Instructions
  4. Show All Help Pages
  5. Contact Information
  6. Atomic Learning
  7. CedarInfo
  8. CedarNet
  9. Google Apps
  10. Google Calendar
  11. Google Drive
  12. Google Groups
  13. Google Mail
  14. Google Sites
  15. Microsoft Excel
  16. Microsoft Outlook
  17. Microsoft PowerPoint
  18. Microsoft Word
  19. Miscellaneous
  20. Moodle
  21. Other Software
  22. Personal Computers and Devices
  23. TechStop
  24. University Hardware
  25. Windows

How to Reverse Case of Text in Excel

How to reverse case of text in Excel.

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 Excel 2016 and 2013. (Terms may vary between versions, but the steps should remain the same.)

  1. Next to the column or row that contains the text you would like to change, insert another column or row > Select the first cell in that column or row.
  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.
  4. Next to the "Text" field, click the spreadsheet icon.
  5. Click the first cell in the row or column that you would like to change the text case.
  6. Click on the spreadsheet icon again in the "Function Arguments" pop-up > Click [OK].
  7. In the cell where the text converted to the desired case, click the small square in the bottom right corner of the cell and drag down to convert the rest of the adjacent column or row's text.
  8. When you have an entire column or row with the desired text, copy and past the text into the original column or row > Delete the duplicate column or row that you created in step 1.

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

Posted in Computer Help