PROPER Function

About

PROPER function in Excel, capitalizes every word of a text string.

Function Type

Text

Purpose

Convert the first letter of every word to ‘capital letter’ and other letters into ‘small letters’.

Return value

Text in proper case

Syntax

=PROPER(text)

Arguments

text – text to be converted into proper case


Example


Notes

Proper function ignores numbers.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel