LOWER(text)

Returns the text string with all the characters converted to lower case.


textThe text string you want to convert to lowercase.

* 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 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 upper case.
* For the Microsoft documentation refer to support.office.com.

 A
1=LOWER("SOME TEXT") = some text
2=LOWER("BETTER SOLUTIONS") = better solutions
3=LOWER("BETTER solutions") = better solutions
4=LOWER("a1b2c3d4") = a1b2c3d4
5=LOWER("A1B2C3D4") = a1b2c3d4
6=LOWER("123456789") = 123456789


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top