Converts all the characters in the string to lowercase.
= LOWER(value)
value |
A string which is to be converted to lowercase. The value can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string (“Word”), or as the value of a variable (e.g, FirstName). |
String
In the case of an error, the function displays an error message: “LOWER(value): Error message”
The function can be used in combination with other functions.
Example |
Returns |
= LOWER(“TeSt”) |
“test” |
= LOWER(“Iron Speed Designer”) |
“iron speed designer” |
= LOWER(Product) |
The lower case converted version of the value of Product. |
= LOWER(FirstName) |
The lower case converted version of the value of FirstName. |
= LOWER(RIGHT(“Iron Speed Designer”, 8)) |
A lower case version of the extracted string. |
= LOWER(CONCATENATE(“Iron”, “Speed”, Designer”)) |
A lowercase version of the concatenated string. |