Converts all uppercase letters in a text string to lowercase.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
LOWER(text)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")결과: excel
Converts the uppercase word 'EXCEL' to lowercase.
=LOWER("Data 2024")결과: data 2024
Converts letters to lowercase while leaving numbers and spaces as they are.
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.