PROPER function in Excel

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.

PROPER () function in Excel During the process of importing data in Excel, sometimes because of fast typing, you skipped capitalizing the first letter of the data. Instead of spending time fixing each data, you can use the PROPER () function to save repair time. The PROPER () function will help you capitalize the first letter of words and convert all other characters to lowercase.

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

PROPER function in Excel Picture 1PROPER function in Excel Picture 1

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)

Inside:

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.

PROPER function in Excel Picture 2PROPER function in Excel Picture 2

- Reference to the cell containing the text string.

PROPER function in Excel Picture 3PROPER function in Excel Picture 3

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.

Hopefully the article will help you, wish you success!

4 ★ | 1 Vote