LCASE(string)

Returns the text string with all characters converted to lowercase (String).


stringThe text string you want to convert to lowercase (String).

REMARKS
* If "string" is Null, then Null is returned.
* All non letter characters remain unchanged.
* You can use the LCASE$ function to return a String data type instead of a Variant/String data type.
* You can use the UCASE function to convert to uppercase.
* The equivalent Excel function is Application.WorksheetFunction.LOWER
* The equivalent .NET function is Microsoft.VisualBasic.Strings.LCase
* For the Microsoft documentation refer to docs.microsoft.com

LCase("LOWERCASE") = "lowercase" 
LCase("LowerCase") = "lowercase"
LCase("lowercase") = "lowercase"

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