LOWER

LOWER(text)

Returns the text string with all the characters converted to lowercase.

text

The text string you want to convert to lowercase.

REMARKS

* The "text" can be a cell reference or a text string.
* Any characters that are numbers will not be changed.
* Any characters that are symbols or special characters will not be changed.
* Any characters that are not text will not altered.
* You can use the ISTEXT function to return the boolean True or False depending if the value is text.
* You can use the PROPER function to return a text string with the first letter of every word as a capital letter.
* You can use the UPPER function to return a text string with all the characters converted to uppercase.
* The equivalent VBA function is VBA.LCASE
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=LOWER("Better Solutions") = better solutions
2	=LOWER("better SOLUTIONS") = better solutions
3	=LOWER("better SOLUTIONS") = "better solutions"
4	=LOWER("Microsoft Office Add, ins") = microsoft office add-ins
5	=LOWER("BE MORE Productive") = be more productive
6	=LOWER("Should't") = should't
7	=LOWER("123456789") = 123456789
8	=LOWER("a1b2c3d4") = a1b2c3d4
9	=LOWER("A1B2C3D4") = a1b2c3d4