Convert text to mixed case (initial caps)

[BSman]

There used to be a function in good old basic that would convert text so the first letter of each word was capitalized and the remaining letters were lower case. All I can find in the VBA references are LCase (all to lower case) and UCase (all to upper case). Is there a function available to do this very useful function?

 

[Golom]

There is indeed

StrConv ( "CONVERT this TO proper CASE", 3 )

produces

Convert This To Proper Case

 

[BSman]

That certainly does the job, and it was possible to find in the on line help or books by looking up things like case or convert.

Thanks a lot for your help.