How to capatilize First letter of two string eg. “emirati plan” it should be like “Emirati Plan”
implement below logic
variable → variable1 (string)
string.Join(" ",Split(StrConv(Join$(variable1.Split(" "c), " "), vbProperCase), " "))
arr = Split(StrConv(Join$(arr, " "), vbProperCase), " ")
An alternative is to use TextInfo from .Net, Here is an example. You can wrap your string variable in place of my name on the expression.
New Globalization.CultureInfo("en-US",False).TextInfo.ToTitleCase("florent salendres")
Please refer the below post.
thanks all for the help