Excel: LCase Function (VBA only)

In Excel, the LCase function converts a string to lower-case.

The syntax for the LCase function is:

LCase( text )

Text is the string that you wish to convert to lower-case.

Applies To:

For example:

LCase("Tech on the Net") would return "tech on the net"

LCase("124ABC") would return "124abc"

VBA Code

The LCase function can only be used in VBA code. For example:

Dim LResult As String

LResult = LCase("This is a TEST")

In this example, the variable called LResult would now contain the value "this is a test".