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.

Starting this tool

Additional keywords to help you find 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

Tip:Alt+P for the previous tool.