Excel LOWER Function
Summary
The Excel LOWER function returns a lower-case version of a given text string. Numbers and punctuation are not affected.
Purpose
Convert text to lower case
Return value
Text in lower case.
Syntax
=LOWER (text)
Arguments
- text - The text that should be converted to lower case.
Usage notes
- All letters in text are converted to lower case.
- Numbers and punctuation characters are not affected.
LOWER formula examples
To build an email address from a first and last name, you can use a formula based on simple concatenation with help from the LEFT and LOWER functions.
In the example shown, the formula in D5 is:
=LOWER(LEFT(B5)&...
To build email addresses using first and last names, you can use a formula that concatenates values, with help from the LOWER and LEFT functions as needed.
In the example shown, the formula in D5 is:
=LOWER(LEFT(C5)...
To remove some of the natural complexity of text (strip punctuation, normalize case, remove extra spaces) you can use a formula based on the SUBSTITUTE function, with help from the TRIM and LOWER functions.
Context...
Related videos
In this video, we show how to use the UPPER, LOWER, and PROPER functions to transform case with a formula.
Related functions
Good links
