Excel 2007 LOWER Function

One of Excel's TEXT functions

When text data is imported or copied into an Excel spreadsheet sometimes the words have incorrect capitalization.

To convert this text all to lower case (small letters) in Excel you can use the LOWER function.

The syntax for the LOWER function is:

= LOWER ( Text )

Text - the text you want to change. This can be a cell reference, a word or words enclosed in quotation marks, or a formula that outputs text.

Example Using Excel's LOWER Function:

Note: For help with this example, see the image to the right.

1. Enter the following text (all in capitals) into cell D1: INCOME STATEMENT.
   
   
2. Click on cell E1 in the spreadsheet - this is where the function will be located.
   
   
3. Click on the Formulas tab of the ribbon menu.
   
   
4. Choose Text from the ribbon to open the function drop down list.
   
   
5. Click on LOWER in the list to bring up the function's dialog box.
   
   
6. In the dialog box, click on the Text line.
   
   
7. Click on cell D1 in the spreadsheet.
   
   
8. Click OK.
   
   
9. The line of text income statement should appear in cell E1 all in lower case.
   
   
10. When you click on cell E1 the complete function = LOWER ( D1 ) appears in the formula bar above the worksheet.

• Excel 2007 PROPER Function
• Excel 2007 RIGHT Function
• Excel 2007 TRIM Function