how to use excel lower function

Quick Intro

Excel LOWER Function can convert a text into lower case in which all letters are in the small case. In simple words, all the alphabets will be in the small letter.

For example, EXCELCHAMPS will be converted into excelchamps.

Syntax

LOWER(text)

  • text A Text which you want converts to lower case.

More Information on LOWER Function

  • Anything other than letters will remain unaffected. There will be no change in numbers, special characters & punctuation.
  • If 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.

Example

In the below example, I have compared lower case, upper case, proper case, and sentence case with each other. Lower case text has all the letters in a small case compared to others.

Example For Excel LOWER Function

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel LOWER Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have UPPER | PROPER function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.