Converts a specified string to lowercase. Learn more
In Google Sheets, the LOWER function is a text function that converts any uppercase letters in a specified text string to lowercase. It takes a single argument, which is the text you want to convert to lowercase.
Here's the syntax for the LOWER function: LOWER(text)
text: This is the text string you want to convert to lowercase. It can be a cell reference, a text string enclosed in quotation marks, or a formula that returns a text string.
The LOWER function is commonly used when you want to standardize text by converting all uppercase letters to lowercase. For example, if you have a column with names in uppercase letters and you want to convert them to lowercase for consistency, you can use the LOWER function. Here's an example:
A1: JOHN DOE B1: =LOWER(A1)
In this example, cell B1 will display "john doe" after applying the LOWER function to the text in cell A1.