How to Convert Strings to Lower Case Using VBA


You can use the LCase function in VBA to convert strings to lowercase.

You can use the following syntax to convert a range of cells with strings to lowercase:

Sub ConvertToLowerCase()
    
    Dim i As Integer

    For i = 2 To 10
        Range("B" & i) = LCase(Range("A" & i))
    Next i
    
End Sub

This particular example will convert each string in the range A2:A10 to lowercase and display the results in the range B2:B10.

The following example shows how to use this syntax in practice.

Example: Convert Strings to Lowercase Using VBA

Suppose we have the following column of strings in Excel:

Suppose we would like to convert each string in column A to lowercase and display the results in column B:

We can create the following macro to do so:

Sub ConvertToLowerCase()
    
    Dim i As Integer

    For i = 2 To 10
        Range("B" & i) = LCase(Range("A" & i))
    Next i
    
End Sub

When we run this macro, we receive the following output:

Column B displays each string in column A in lowercase.

Note: You can find the complete documentation for the LCase function in VBA here.

Additional Resources

The following tutorials explain how to perform other common tasks in VBA:

How to Compare Strings in VBA
How to Remove Spaces from String in VBA
How to Replace Characters in String in VBA

Leave a Reply

Your email address will not be published. Required fields are marked *