We're nominated again this year for Best Microsoft Excel Add-in at the Global Excel Awards! ❤️🌟
If ASAP Utilities has helped you in Excel, you can support it with a quick vote→. It only takes about 30 seconds.
Find us in the second category: Best Microsoft Excel Add-in. You can skip other categories if you're unsure about them.
logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Saturday April 18th, 2026

Tip of the Day | Saturday April 18th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Change Text Case with Multiple Capitalization Options...

This tool changes the text in your selected cells to uppercase, lowercase, or other common capitalization styles.
It works on both plain values and formulas.
You can choose from the following case styles:
  • lowercase - changes all letters to lowercase
  • UPPERCASE - changes all letters to uppercase
  • tOGGLE cASE - switches uppercase to lowercase and vice versa
  • Sentence case - capitalizes the first letter of each sentence
  • Glossary case - makes the first letter of each sentence lowercase
  • Capitalize Each Word - capitalizes the first letter of each word and makes the rest lowercase
    You can optionally define which characters (besides a space) start a new word, such as hyphens or slashes
    Options:
  • Preserve all capitalized text - useful when converting glossaries or datasets that include acronyms (e.g., "SKU" stays "SKU")
  • Set words to exclude from conversion - skip specific product codes or terms (e.g., "VAT", "PowerPoint", or "Excel") that should keep their original capitalization
    Examples:
  • lowercase: "Customer Name" → "customer name"
  • UPPERCASE: "Customer Name" → "CUSTOMER NAME"
  • tOGGLE cASE: "Customer Name" → "cUSTOMER nAME"
  • Sentence case: "order received. payment pending." → "Order received. Payment pending."
  • Glossary case: "Order Received. Payment Pending." → "order Received. payment Pending."
  • Capitalize Each Word: "customer name" → "Customer Name"
    This tool is helpful when cleaning up imported data, standardizing text formatting, or preparing consistent labels, glossary terms, or text used in reports.

    Screenshots

    Text  ›  Change Text Case with Multiple Capitalization Options...

    Starting this tool


    Text  ›  Change Text Case with Multiple Capitalization Options...

    Choose your language preference below

    English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

    Trustpilot
    Download  


    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.