The ASAP Utilities menu in Excel (English)
Change to Capitalize First Letter and Lowercase the Rest
ASAP Utilities › Text › 5. Change to Capitalize First Letter and Lowercase the RestThis 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:
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
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
- 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...
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
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
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Change to Capitalize First Letter Only |
©1999-2025 ∙ 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 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 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.