Excel PROPER Function Tips

Making the characters uppercase and lowercase

Using UPPER(), LOWER() and PROPER() functions with NESTED IF().

Making words proper

Using PROFER() formula.