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
If you want to change case in Excel, you'll need to use the UPPER, LOWER, or PROPER functions. Together with other functions they give you the tools to transform case.
Related functions
Good links
