How odd! You could just replace it and then replace it back

=SUBSTITUTE(PROPER(SUBSTITUTE(A27,"'","QAZ")),"qaz ","'")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"borobutch" wrote in message
...
When using PROPER to capitalise text, how do you get "CAN'T" to become
"Can't" instead of "Can'T".