Tip Printed from ExcelTip.com

---

Converting Uppercase Letters to Lowercase


Use the LOWER function to convert all uppercase letters in a text string to lowercase.

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



Example:

Text in uppercase: GEORGE W. BUSH

The function: =LOWER(A1)

Result: george w. bush