ASAP Utilities, description of our Excel toolsEnglish (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語
Text » Start Each Word With UppercaseThis utility will start each word in the selected cells with a capital.
All other characters will be converted to lowercase.
For example the text 'new york' is changed to 'New York'.
You can use this as a quick alternative for Excel's =PROPER() function. There is however a difference. This utility only converts the first letter of every word (the first word and everything after a space) to uppercase. But Excel's =PROPER() also capitalizes all letters in the text that follow any character other than a letter.
This utility can be useful with for example city names.
Practical tricks on how this can help youPractical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!
Starting this utilityIn the Excel menu choose: ASAP Utilities » Text » Start Each Word With Uppercase
« Return to the list of “Text” tools.
Download ASAP Utilities
Additional keywords for this tool:
Change Case, Changing Case, Caps, Capitals, Capital letter, capitalization, capitalisation, majuscule, upper-case letter, upper case, uppercase, title case, shift F3 Excel, transform text from without retyping
Follow ASAP Utilities on Facebook
List of all utilities
Printer friendly page
^ Back to Top