Excel FunctionsLesson 92Free preview

LOWER

This lesson is part of Excel · All levels

Summary

LOWER is an Excel text function that converts all the letters in the text into lowercase letters. The syntax is. This function does not change numbers, symbols, or spaces so it is safe to use to unify name or email data.

Key points

Syntax: LOWER(text) changes the capital to small
Numbers, symbols, and spaces are unaffected
The result is a new text, the original data is unchanged.
Alloys with UPPER and PROPER for data aggregation

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.