PROPER Function in Excel: Syntax, Examples and Free Practice
PROPER is an Excel Text function. Capitalizes the first letter of each word.
PROPER syntax
=PROPER(text)
Arguments
text: The text to work with
When to use PROPER
PROPER is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice PROPER online, free
Open the live Excel-style spreadsheet and try PROPER yourself. No Excel install or sign-up needed to start.
Practice PROPER now →Watch: PROPER in Excel
More Text functions
Frequently asked questions
What does the PROPER function do in Excel?
Capitalizes the first letter of each word.
What is the syntax of PROPER in Excel?
The syntax is =PROPER(text). text: The text to work with.
Where can I practice PROPER online for free?
Open the free live spreadsheet on Cellgrids and try PROPER yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts