It converts all letters in a string to lowercase.
The syntax of the function is the following:
LOWER(text)
text: The text you want to convert to lowercase.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the LOWER function:
Insert the appropriate function in the cell A2 that changes the format on the contents of the cell A1 to title case.
Insert the appropriate function in the cell A3 that changes the format on the contents of the cell A1 to uppercase.
Insert the appropriate function in the cell A4 that changes the format on the contents of the cell A1 to lowercase.