Excel PROPER Function

Summary
The Excel PROPER function capitalizes words given text string. Numbers and punctuation are not affected.
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.
Version
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.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.