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 11th, 2026

Tip of the Day | Saturday April 11th, 2026

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

Change to Capitalize Each Word (Title Case)...

This tool capitalizes the first letter of each word in your selected cells and converts the remaining letters to lowercase.
It works on both plain values and formulas.
You can use this as a quick alternative to Excel's =PROPER() function.
Options:
  • Follow Excel's PROPER() capitalization (include hyphens, apostrophes, etc.)
    When enabled, the tool also capitalizes the first letter and any letters that follow non-letter characters (such as hyphens, apostrophes, or slashes), similar to Excel's built-in PROPER() function.
    All other letters are converted to lowercase.
    When disabled (default behavior), only the first character of each word separated by spaces is made uppercase, and the rest of the word is converted to lowercase.
    Examples:
    Without the option (default):
  • "o'brian" becomes "O'brian"
  • "sign-in required" becomes "Sign-in Required"
  • "read-only file" becomes "Read-only File"
  • "out-of-date data" becomes "Out-of-date Data"
  • "john's laptop" becomes "John's Laptop"
    With the option enabled:
  • "o'brian" becomes "O'Brian"
  • "sign-in required" becomes "Sign-In Required"
  • "read-only file" becomes "Read-Only File"
  • "out-of-date data" becomes "Out-Of-Date Data"
  • "john's laptop" becomes "John'S Laptop"
    This is useful for formatting names, city names, book titles, or any text that should appear in standard title-style capitalization.
    The default setting helps avoid overcapitalizing brand names, technical terms, or hyphenated words.

    Screenshots

    Text  ›  Change to Capitalize Each Word (Title Case)...

    Starting this tool


    Text  ›  Change to Capitalize Each Word (Title Case)...

    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.