How To Use Excel LOWER Function

    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.