PROPER function

Category: Text
Introduced: Excel 2003

Summary

Capitalizes the first letter in each word of a text value

Syntax

PROPER(text) The PROPER function syntax has the following arguments:
• 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.

Example

=PROPER(A2)
=PROPER(A3)
=PROPER(A4)

Microsoft Support Page

https://support.microsoft.com/en-us/office/proper-function-52a5a283-e8b2-49be-8506-b2887b889f94

Back to Functions