Exceljet

Quick, clean, and to the point

Excel LOWER Function

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.
Related functions 
Excel UPPER function
Excel UPPER Function

The Excel UPPER function returns a upper-case version of a given text string. Numbers and punctuation are not affected.

Excel PROPER function
Excel PROPER Function

The Excel PROPER function capitalizes words given text string. Numbers and punctuation are not affected.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

500 Formula Examples, thoughtfully explained.