Converts all uppercase letters in a text string to lowercase.
構文
LOWER(text)引数
text必須
The text you want to convert to lowercase.
The LOWER function takes a text string and returns a new string where every uppercase character is transformed into its lowercase equivalent. Non-alphabetic characters, such as numbers and symbols, remain unchanged by this function.
=LOWER("EXCEL")→excelConverts the uppercase word 'EXCEL' to lowercase.
=LOWER("Data 2024")→data 2024Converts letters to lowercase while leaving numbers and spaces as they are.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =LOWER( followed by the cell reference or text string, then close the parenthesis.
Execute
Press Enter to see the converted lowercase text.
No, the LOWER function only affects alphabetic characters and ignores numbers and symbols.
LOWER is designed for single strings, but you can use it in an array formula or drag the fill handle to apply it to a range.