Fix the case of names with PROPER
PremiumIn B2, use PROPER to write the name in A2 with a capital first letter in each word.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Name as typed | Name | ||||
| 2 | aNNA bERG | |||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock TRIM, PROPER and UPPER and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Next with premium:LEFT, RIGHT and MIDFIND and SEARCH
Need help?
Why this works
PROPER makes the first letter of every word a capital and the rest small letters, so "aNNA bERG" becomes "Anna Berg". UPPER and LOWER do the whole text in capitals or in small letters.
Common mistake: Using PROPER on codes or abbreviations. "VAT no" becomes "Vat No", so keep PROPER for names.
The answer
- B2
=PROPER(A2)
Use =PROPER(A2). It makes the first letter of every word a capital and the rest small letters.