One way to trick it would be to use something like

=SUBSTITUTE(PROPER(SUBSTITUTE(A1,"'","zzz")),"zzz" ,"'")


Regards,

Peo Sjoblom

"Josh Ross" wrote:

The proper function incorrectly capitalizes the letter after an apostrophe.

Language US-EN 1033