The PROPER function capitalizes the first letter of each word and converts the remaining letters into lowercase. In this guide, we’re going to show you how to use the this function and also go over some tips and error handling methods.
- All Excel versions
The text you want converted into a style where first letter of each word is capitalized, and the rest made lowercase.
- Try UPPER function to convert strings into uppercase.
- Try LOWER function to convert strings into uppercase.
- The PROPER function can’t recognize suffixes that are separated with a punctuation character. So, the function capitalize them as well. For example; =PROPER(“Ash’s Pikachu”) returns “Ash’S Pikachu“