logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Change to Capitalize First Letter and Lowercase the Rest

ASAP Utilities  › Text  ›  5. 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  ›  5 Change to Capitalize First Letter and Lowercase the Rest
    ASAP Utilities makes YOU rock in Excel!

    Practical tricks on how this can help you

    Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

    Starting this tool


    Text  ›  5 Change to Capitalize First Letter and Lowercase the Rest
    Additional keywords for this tool:
    Capitalize first letter and lowercase the rest, Change all caps to sentence case, Convert text to sentence-style capitalization, Capitalize first word only, Proper case but only first word, Change case without formula, Fix text capitalization, Make first letter uppercase rest lowercase Excel, Convert uppercase to proper capitalization, Text transform first letter capital, Partial proper case tool, Change to first word capital only, Capitalize beginning of cell content, Fix inconsistent capitalization, Change cell to start with capital letter, Clean up text to look like sentence, Fix text casing without retyping



  • 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 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.