Home > Excel Function > Excel LOWER Function

Syntax For Excel LOWER Function

 

What is the Use of Excel Lower Function?

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. [Required]

More Information

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

Examples to understand

Example For Excel LOWER Function

In above example, I have compared lower case, upper case, proper case & sentence case with each other. Lower case text has all the letters into small case compared to other cases.

Download Sample File

Download Sample File To Learn Excel LOWER Function

More Tips Related With Excel LOWER Function

Conclusion

By using Excel LOWER Function you can streamline your text. Learn more about LOWER from here.

Related Functions

Upper | Proper

Excel Functions | Excel Formulas