logo ASAP Utilities

Tip of the Day | Sunday May 24th, 2026

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

Change to Capitalize First Letter and Lowercase the Rest

This tool capitalizes the first letter it finds in each selected cell and converts the remaining characters to lowercase.
It works on both plain values and formulas.
For example:
  • "THIS IS A TEST" becomes "This is a test"
  • "product NAME 123" becomes "Product name 123"
  • "123 TEST" becomes "123 Test"
  • "ERROR: OUT OF STOCK" becomes "Error: out of stock"
    This is useful when you want your text to start with a capital letter and have the rest in lowercase.
    It helps clean up things like product names, task labels, data exports, or text shown to customers.
    This tool does not apply full sentence case. It only changes the first letter it finds to uppercase and converts the rest to lowercase, without checking punctuation or sentence structure.

    Screenshots

    Text  ›  Change to Capitalize First Letter and Lowercase the Rest

    Starting this tool


    Text  ›  Change to Capitalize First Letter and Lowercase the Rest

    Choose your language preference below

    English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語



  • 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.