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
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...
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,...
Related videos
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.
In this video, we show how to use the UPPER, LOWER, and PROPER functions to transform case with a formula.
Related functions
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
