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

Syntax

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

Output

VBA StrConv Function

Example 2

Output

VBA StrConv Function2

Example 3

Output

VBA StrConv Function3

Pin It on Pinterest

Share This