How do I use PROPER in Excel?
Use PROPER when you want to capitalize each word. Enter Text in that order, then add optional arguments when needed.
Excel Function
PROPER
Capitalizes the first letter of each word.
PROPER(text)Arguments
text
RequiredEnter a text value (wrap with quotes when needed).
Practice Preview
Use PROPER to capitalize the first letter of each word in cell B2 (Name in column B).
Example Table
| # | AEmployee ID | BName | CEmail | DPayment Amount | EAmount Text |
|---|---|---|---|---|---|
| 2 | E001 | tanaka taro | t.tanaka@example.com | 1200 | 1200 |
| 3 | E002 | Hanako Suzuki | h.suzuki@example.com | 980 | 980 |
| 4 | |||||
| 5 | |||||
| 6 | |||||
| 7 | |||||
| 8 |
How to Use (Formula)
=PROPER(B2)Result
Tanaka Taro
Practice This Function
PROPER FAQ
Where can I practice PROPER?
Use the "Start Function Practice" button to jump straight into PROPER drills.
What arguments does PROPER use?
The main arguments are Text. Enter them in order.