A to Z of Excel Functions: The LOWER Function
10 December 2021
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the LOWER function.
The LOWER function
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2021/a-to-z/280/image1.png/e774d10cbbb9450fc45efbe51abdf434.jpg)
This function converts all uppercase letters in a text string to lowercase.
The LOWER function has the following syntax:
LOWER(text)
The LOWER function has the following arguments:
- text: this is required and represents the text you wish to convert to lowercase.
It should be noted that:
- LOWER does not change characters in text that are not letters.
Please see my comprehensive example below:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2021/a-to-z/280/image2.png/f32e5a15e2cf9c3e4d2d058458ce054d.jpg)
We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every business day.
A full page of the function articles can be found here.