Quick Navigation

PROPER Function

Excel 2007+

Summary

The Excel PROPER function capitalizes the first letter of each word in a text string while converting all other letters to lowercase. It's perfect for formatting names, titles, and headings into proper title case automatically.

Syntax

PROPER(text)

Parameters

Parameter	Type	Required	Description
text	`Text`	Yes	The text string to convert to proper case. Can be a direct text value, cell reference, or formula result.

Using the PROPER Function

PROPER is commonly used to standardize text formatting for display purposes. It automatically converts text to title case format, making it ideal for cleaning up imported data, formatting customer names, or creating professional-looking headings.

Common PROPER Examples

Basic Title Formatting

=PROPER("this is a TITLE")

Converts all uppercase text to proper title case.

Street Address Cleanup

=PROPER(A2)

Formats messy address data like "2-way street" into "2-Way Street".

Mixed Numbers and Text

=PROPER("76BudGet")

Handles alphanumeric strings correctly, preserving numbers.

Frequently Asked Questions

No, PROPER only affects letters. Numbers and punctuation remain unchanged.

PROPER capitalizes after any non-letter character (space, hyphen, number, etc.).

Yes, it works with any formula that returns text.

Common Errors and Solutions

#VALUE! error

Cause: Input is not text or cannot be converted to text

Solution: Ensure the text argument contains valid text data

Notes

Apostrophes and hyphens are treated as word separators
Numbers followed by letters get capitalized correctly
Use UPPER or LOWER for full case conversion instead

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in:

Content last reviewed: December 11, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+