Excel VBA StrConv Function

The StrConv function in VBA converts a string into a specified format.

Syntax

StrConv (String, Conversion, [LocaleID])

Parameter

String (required) – This parameter represents the string to be converted.

Conversion (required) – This parameter specifies the type of conversion.

It can have any of the following values:

• vbUpperCase
• vbLowerCase
• vbProperCase
• vbWide
• vbNarrow
• vbKatakana
• vbHiragana
• vbUnicode
• vbFromUnicode

LocaleID (optional) – This parameter specified the LocaleID. It uses the system LocaleID as the default value.

Return

This function returns a string after converting it to a specified format.

Example 1

Sub StrConv_Example1()
 'Converting the String "Hello VBA" to upper case with StrConv function.
 Dim str As String
 Dim text As String
 text = "Hello VBA"
 str = StrConv(text, vbUpperCase) 
 'Converting the String "Hello VBA" to upper case with StrConv function.
 Dim str As String
 Dim text As String
 text = "Hello VBA"
 str = StrConv(text, vbUpperCase)
 ' The variable will return "HELLO VBA".
 Cells(1, 1).Value = str
 End Sub 

Output

HELLO VBA

Example 2

Sub StrConv_Example1()
 'Coverting the String "Hello VBA" to lower case with StrConv function.
 Dim str As String
 Dim text As String
 text = "Hello VBA"
 str = StrConv(text, vbLowerCase)
 ' The variable will return "hello vba". 
 Cells(1, 1).Value = str
 End Sub 

Output

Hello vba

Example 3

Sub StrConv_Example1()
 'Coverting the String "Hello VBA" to proper case with StrConv function.
 Dim str As String
 Dim text As String
 text = "Hello VBA"
 str = StrConv(text, vbProperCase)
 ' The variable will return "Hello Vba".
 Cells(1, 1).Value = str
 End Sub 

Output

Hello Vba