PROPER
Capitalizes the first letter of each word and makes the rest lowercase: fixes names and cities typed any which way.
PROPER(text)- text
- The cell or text to convert to "Like A Name" style.
Return value
Text in which each word starts with a capital letter and the other letters are lowercase.
Examples
Customer names
fx
A
B
C
1
2
3
4
5
6
7
From form
Customer
john smith
EMILY DAVIS
mIKE bROWN
sarah johnson
Sheet1
Details
PROPER raises the first letter of each word and lowers all the others: "jOHN smith" becomes "John Smith".
For the function, a new word starts after a space, a dash or any other character that isn't a letter. That's why "winston-salem" becomes "Winston-Salem".
Common mistakes
- Abbreviations get spoiled: "LLC" becomes "Llc", "IBM" becomes "Ibm".
- Some names get it wrong: "mcdonald" becomes "Mcdonald", and "of" in "bank of america" becomes "Of".
- Extra spaces stay. Combine it with TRIM.