Beginner Text

PROPER

Capitalizes the first letter of each word in a text string, converting the rest to lowercase.

Compatibility: All Excel versions

Syntax

Example

When to Use It

Use PROPER to clean up names or titles that were entered in all-caps or all-lowercase, turning them into a properly capitalized format.