Description
LOWER Function converts all uppercase letters in a text string to lowercase.
If you want to converts all lowercase letters in a text string to uppercase, please use UPPER function
Syntax
LOWER(text)Parameters
Text Required. The text you want to convert to lowercase. LOWER does not change characters in text that are not letters.
Examples
The example may be easier to understand if you copy the example data (include header) in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.
| Data | Formula | Result | Description |
|---|---|---|---|
| Excel Bible | =LOWER(A2) |
excel bible | Lower case of text string. |
| ExcelBaby | =LOWER(A3) |
excelbaby | Lower case of text string. |
| Excel 2019 | =LOWER(A4) |
excel 2019 | Lower case of text string. |