Excel PROPER Function: Proper Capitalization, Use It!
The Excel PROPER Function is another Text manipulation function that will capitalize the first letter of each word in a string of text. It is yet another one of the most used functions that is great to know, when you need to create a title or simply need to perform this task.
Excel PROPER Function:
Syntax of the Excel PROPER Function:
- text (Required) - Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.
- =PROPER("dr. strange") = Dr. Strange
- =PROPER("BOOGIE MAN") = Boogie Man
- =PROPER("Can't shouldn't WON'T") = Can'T Shouldn'T Won'T
- =PROPER("rOdNeY daNGerFIelD") = Rodney Dangerfield
What's The Deal With The Highlighted Cells?
This is just to show that the Excel PROPER Function will work with cells that contain formulas that return text. In this case the Excel UPPER Function is used to fully capitalize the text in cell A6. The Excel PROPER Function, in cell B20, refers to the formula in cell B10 and not to the actual text in cell A6.
All Right Then What About The Apostrophe Issue?
I'm Glad I Asked! Umm .. You Asked! ... Didn't you? 😛
Just like it handles words with numbers or other symbols, Excel ignores the apostrophe and will capitalize the letter following it. So this is unfortunate when your text uses a lot of contractions, such as Can't, Won't, Shouldn't, Couldn't, Wouldn't and so on.
Download The Example Spreadsheet Here:
Why use the Excel PROPER Function?
Rather than tediously capitalizing the first letter of each word yourself, the Excel PROPER Function does it for you quickly and almost accurately. It certainly saves time over the manual process. It's great for titles or headings or if you have a column full of names, that were entered using different variations of upper and lowercase letters.
If your goal is to be more efficient with Excel, then getting to know the most popular functions is certainly a great way to start. While you may not need this function as often as others, it does save you time and is therefore useful for its purpose.
Share, Comment, Ask a Question or Rip Me a New One!
If you liked this article, please feel free to share it on social media and comment below if you have any suggestions, questions or corrections. Thank you for reading!
Remember to sign up to the newsletter email list, so you can catch all of the new posts and learn about upcoming topics, products and/or services.