PROPER Function in Excel: Syntax, Examples, and Tips

This article provides a clear overview of PROPER Function in Excel, with the main facts, useful context, and practical details organized for easy reading.

For the syntax and usage of the PROPER () function, follow the article below.

Description

The PROPER () function capitalizes the first letter in a text string if it's a non-letter character (for example, a space) and converts all other letters to lowercase.

Syntax

= PROPER (text)

Arguments

text is the first string of uppercase text enclosed in quotation marks, required parameters.

Text can be a text string, a formula that returns text, or a cell reference to the text string in uppercase.

For Example

- Enter the text string directly into the function.

- Reference to the cell containing the text string.

The article described the syntax and usage of the PROPER () function in Excel, how to use the function is quite simple but effective that PROPER () brings great results. PROPER () function has a great application in practice, is widely known and used.