Home Screenshots 10 Languages Why use it?

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

Click ASAP Utilities › Text › 5. Change to Capitalize First Letter and Lowercase the Rest
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Choose your language preference below

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

Today's Tip

Download

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

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