Lcase function is to converted String from Uppercase to Lowercase or small capital letters for example your text String is "My Name" then returns "my name".
Syntax : Lcase(String) , Returns : Lowercase String
All Uppercase letters with be changed to Lowercase and others remain.
VBA Vode:
Option Explicit
Sub Examples_Lcasefunction()
Dim StrTxtA As String, StrTxtB As Variant
StrTxtA = "My Car Number PRS123"
StrTxtB = Null
Debug.Print LCase(StrTxtA) ' my car number prs123
Debug.Print LCase(StrTxtB) ' Null
End Sub
Sub Examples_Lcasefunction()
Dim StrTxtA As String, StrTxtB As Variant
StrTxtA = "My Car Number PRS123"
StrTxtB = Null
Debug.Print LCase(StrTxtA) ' my car number prs123
Debug.Print LCase(StrTxtB) ' Null
End Sub
Note:
For Null consider not string even we use Lcase on Null it will remain unchanged.
excel programming, excel vba at below links.
Microsoft Reference-Lcase-function
Other Reference-Lcase-function
Leave your comments if you have any request.
Practice makes perfect.
Thank You.
No comments:
Post a Comment