Tip Printed from ExcelTip.com

---

Converting Text to Its Proper Case


Use the PROPER function to convert text to its proper case.

The Proper function is in the Text category in the Insert Function dialog box.

Example:

Text in uppercase: GEORGE W. BUSH
The function: =PROPER(A1)
Result: George W. Bush