Excel PROPER Function

Excel PROPER Function

Capitalize the first letter in each word

Return value 
Text in proper case.

=PROPER (text)

  • 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