LCASE

LCASE(string)

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


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

REMARKS
* If "string" = "" (zero length string), then a zero length string is returned.
* If "string" is vbNullString, then a zero length string is returned.
* All non letter characters remain unchanged.
* You can use the LCASE$ function to return a String data type instead of a Variant data type.
* You can use the LTRIM function to return a text string without leading spaces.
* You can use the STRCONV function to convert to propercase.
* You can use the UCASE function to return a text string with all the characters converted 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 learn.microsoft.com

Debug.Print LCase("LOWERCASE")    '= "lowercase"  
Debug.Print LCase("LowerCase") '= "lowercase"
Debug.Print LCase("lowercase") '= "lowercase"
Debug.Print LCase("123ABC456") '= "123abc456"
Debug.Print LCase("7890") '= "7890"
Debug.Print LCase("%*$#&!") '= "%*$#&!"

Dim sResult As String
sResult = LCase("aBcDe")
Debug.Print sResult '= "abcde"

sResult = LCase("")
Debug.Print "'" & sResult & "'" '= "''"

sResult = LCase(vbNullString)
Debug.Print "'" & sResult & "'" '= "''"

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