Excel FunctionsLesson 102Free preview

PROPER

This lesson is part of Excel · All levels

Summary

PROPER is an Excel text function that converts the first letter of each word into capital and the rest into lowercase. The syntax is. This function is very helpful in standardizing the format of a person's name, address, or title.

Key points

The first letter of each word is capital, the rest is lowercase.
Non-letter characters are considered the starting boundary of a new word
It can change the acronyms into partial capital, for example IBM to IBM.
Mixed with TRIM so that the excess space doesn't interfere

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.