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 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...
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)...
Related videos
In this video, we show how to use the UPPER, LOWER, and PROPER functions to transform case with a formula.
In this video we'll look at how dynamic array behavior is native and deeply integrated in Excel. Even older functions can use this new feature.
Related functions
