LOWER

LOWER(text)

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

textThe 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


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top