Excel PROPER Function

Excel PROPER Function

Purpose 
Capitalize the first letter in each word

Return value 
Text in proper case.

Syntax 
=PROPER (text)

Arguments 
  • text – The text that should be converted to proper case.

Usage notes 

Use PROPER to capitalize each word in a given string.

All letters in text will be converted to lower case before the first letter in each word is capitalized.

Numbers and punctuation characters are not affected.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas
Logo