# Excel LOWER Function

Home ➜ Excel Functions ➜ **Excel LOWER Function (Example + Sample File)**

**What is EXCEL LOWER FUNCTION**

The Excel LOWER Function is listed under Microsoft Excel's Text Functions category. **It returns the string after converting all the letters in small.** In simple words, it converts a text string where all the letters you have are in small letters, numbers will stay intact.

**How to use it**

To learn how to use the LOWER function in Excel, you need to understand its syntax and arguments:

**Syntax**

LOWER(text)

**Arguments**

**text:**The text which you want to convert to the lowercase.

**Notes**

- 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.

**Example**

To master the LOWER function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have compared the lower case, upper case, proper case, and sentence case with each other.

A lower case text has all the letters in a small case compared to others.

**Hey Listen,**

With this Basic Excel Tutorial, you can learn all the basics of Excel which a beginner needs to know, and from here, you can learn the top 100 Microsoft Excel Tips and Tricks to skyrocket your Excel skills.

## Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

**About the Author**

**Puneet Gogia**

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

COPYRIGHT © 2020 • EXCEL CHAMPS