How to Use Excel LOWER Function (Examples + Video)

Excel LOWER Function (Example + Video)

Excel LOWER Function

When to use LOWER Function

LOWER function can be used when you want to convert all uppercase letter in a text string to lowercase.

What it Returns

It returns a text string where all uppercase letter have been converted into lowercase.

Syntax

=LOWER(text)

Input Arguments

  • text – the text string that you want in lowercase.

Additional Notes

  • Characters that are not letters remain unchanged.
    • Numbers, special characters, and punctuations remain unaffected.

Excel LOWER Function – Live Example

Excel LOWER Function – Video Tutorial

Related Excel Functions:

DOWNLOAD FREE EXCEL EBOOK

51 Excel Tips to Save Time & Increase Productivity

(22,000+ Enthusiasts have Already Downloaded)