» Converting Uppercase Letters to Lowercase

CATEGORY - Links between Worksheet and Workbooks VERSION - All Microsoft Excel Versions

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