Change case of cell values

 

Cell Cleaner for Microsoft Excel

How to change words to upper, lower and proper case or capitalize each cell


  1. Expand the Change case section by clicking on the arrows next to Change case. Open the Change case section by clicking on the arrows
  2. Select the range with the values that you want to change.
  3. Select the case you need from the list. You can select one of these four case options:
    • To UPPER case – all the words within selected cells will take upper case; Select the upper case option to change all words to upper case
    • To lower case – the cell values will be changed to lowercase Select the lower case option to change all words to lower case
    • To Proper case – The first letter of each word within a cell will become capital and all other letters will be changed to lower case. Use proper case option to capitalize each word in a cell

      Note! If you have any acronyms in your cells, only the first letter of the abbreviation will keep upper case.

    • Capitalize each cell – the first character in the cell will become capital; Make the first character in each cell capital by choosing this option
  4. Click the Run button to apply changes to the selected range.
 
 
 
 
 
 

Please remember that we work from 9am to 6pm GMT this is 5:00am - 2:00pm EST, 2:00am - 11:00am PST and our public holidays may differ from yours.




Microsoft Office Marketplace logo

License Benefits

  • 30-day money-back guarantee
    If not satisfied, you'll get your money back, no questions asked.
  • 1 license for 3 PCs
    You can install 1 license on 3 PCs: at work, at home and on a laptop.
  • Life-time licenses
    There are no annual or renewal fees.
  • Get the product in minutes
    Instant delivery for credit card payments.
  • All forms of payment
    Pay with any major credit card, wire transfer, Purchase Order, PayPal.
  • Discount for schools & NPO
    Contact us to get your coupon code.
  • Volume discounts
    You can save up to 50%.
  • Free upgrades
    All minor updates are free. Major upgrades are free for 1 year, after 1 year - for half price.
  • Code signed with VeriSign
    The add-ins are signed with the VeriSign Code Signing certificate.
  • Easy corporate deployment
    Please see Installing an add-in for several users
  • Free support
    If you need any help, just contact us.
 
Excel Add-ins Collection - quick way to increase your effectiveness in Excel

Related links





Plug-ins for Microsoft Excel and Outlook

Copyright © 2003 - 2012 Add-in Express Ltd. All rights reserved.

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.