Table of Contents
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.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)