In this post, you will learn how to convert String to proper case with-in your Excel spreadsheet using Excel VBA
Convert String to Proper Case in Excel VBA
To convert a string of text into proper case, you can use the StrConv function .
The StrConv function has two arguments. The first part of argument is the original string and the second part is the conversion case (Lower case, Upper case, Proper case).
Example program for converting a string to proper case in Excel VBA.
Sub Convert_To_ProperCase(): Dim Text As String Dim ProperCase As String Text = "cOnVeRting string to PrOpEr Case fUnctIon" ProperCase = StrConv(Text, vbProperCase) MsgBox ProperCase End Sub