How to Convert Strings to Upper Case Using VBA


You can use the UCase function in VBA to convert strings to uppercase.

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

Sub ConvertToUpperCase()
    
    Dim i As Integer

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

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

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

Example: Convert Strings to Uppercase Using VBA

Suppose we have the following column of strings in Excel:

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

We can create the following macro to do so:

Sub ConvertToUpperCase()
    
    Dim i As Integer

    For i = 2 To 10
        Range("B" & i) = UCase(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 uppercase.

Note: You can find the complete documentation for the UCase 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 *