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.

Try:

StrConv("don't",vbProperCase)

in VBA

--
Jim Rech
Excel MVP
wrote in message
...
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.

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



--
Regards,
Tom Ogilvy


wrote in message
...
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 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.

--
David