Proper Case Odditiy

[Guest]

Excel's Proper() function converts letters following an apostrophy to upper
case, which is almost never what's wanted. For example "don't" becomes
"Don'T".

Is there any excel or VBA function that works "properly", or do I have to
write my one proper case function?

Thanks.

 

[Jim Rech]

Try:

StrConv("don't",vbProperCase)

in VBA

 

[Tom Ogilvy]

? strconv("DON'T",vbProperCase)
Don't
? strConv("don't",vbProperCase)
Don't

 

[David]

Jim Rech wrote

Try:

StrConv("don't",vbProperCase)

in VBA

Thank you! I was having the same problem converting text from a userform
using Payee1 = Application.Proper(UserForm1.TextBox1.Text)
I can now use Payee1 = StrConv(UserForm1.TextBox1.Text, vbProperCase) and
input like sam's club no longer comes out Sam'S Club.