Subscribe for New Post Notifications


How to use the LOWER function in Microsoft Excel

Let's look at some Excel Lower function examples and explore how to use the Lower function as a worksheet function in Microsoft Excel:

LOWER function


The Excel LOWER function will return the lowercase version of the text string given. Numbers and punctuation are not affected when we use LOWER function.
LOWER can be useful in arranging data or creating data in a certain format. For example, we can create an email address from the names available in a data set.
The Lower function is a built-in function in Excel that is categorized as a Text Function.


Convert text to lower case (small letters).

Return value

Text in lower case

What Does It Do ?

This function converts all characters in a piece of text to lower case.


Lower function has one syntax and hence they can be written in Two different ways:

=LOWER(text) or
=LOWER(cell reference)

Parameters or Arguments

Text: A Text which you want converts to lower case.
Cell reference: Reference to cells containing text.


No special formatting is needed.

Usage notes

  • All letters in text are converted to lower case.
  • Numbers and punctuation characters are not affected when we use LOWER function.
  • Anything other than letters will remain unaffected.
  • If the referred text is an error it will return an error in the result.
  • You can also insert text string directly into the function by using double quotation marks.

No comments:

Post a Comment