Excel Function

PROPER

Capitalizes the first letter of each word.

PROPER(text)

Arguments

text

Required

Enter a text value (wrap with quotes when needed).

Practice Preview

format and display text values. Use PROPER to Capitalizes the first letter of each word. use B2 for text. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=PROPER(B2)

Practice This Function

Practice in Sequential Mode Back to Function List