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.
Version
Usage notes
- All letters in text are converted to lower case.
- Numbers and punctuation characters are not affected.
LOWER formula examples
For a name like "Tim Brown", this formula builds an email address like "tbrown@domain.com".
First, the LEFT function is used to get the first letter from the first name in column C. Usually, the LEFT function gets a "...
Working from the inside out, this formula first concatenates the last name in column C with the first letter of the first name from column B:
LEFT(B5)&C5
The LEFT function is normally configured with num_chars,...
The formula shown in this example uses a series of nested SUBSTITUTE functions to strip out parentheses, hyphens, colons, semi-colons, exclamation marks, commas, and periods. The process runs from the inside out, with...
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
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.
