Proper Case Odditiy

[[email protected]]

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

--
Jim Rech
Excel MVP
<[email protected]> wrote in message
news:[email protected]...
> 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.

[Tom Ogilvy]

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



--
Regards,
Tom Ogilvy


<[email protected]> wrote in message
news:[email protected]...
> 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.

[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.

--
David