How to capitalize the first letter of each word (proper case)
✓ Verified in LibreOffice 25.8.7.3Convert text to Title Case, capitalizing the first letter of every word.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =PROPER(A2) | UPPER() for ALL CAPS, LOWER() for all lowercase. |
| Google Sheets | =PROPER(A2) | Identical. |
| LibreOffice Calc | =PROPER(A2) | Identical. |
How it works
PROPER capitalizes the first letter of each word and lowercases the rest. 'john smith' becomes 'John Smith'. Note it also capitalizes after apostrophes and hyphens, so "o'brien" becomes "O'Brien".
Verified, not just documented
We ran =PROPER(A2) in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned John Smith — exactly the expected result. Every formula here is confirmed by actually executing it.