Problem using 'PROPER' with apostrophes

B

borobutch

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

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Excel does not accept text format! 0
apostrophe key produces "division sign" in Word 2008 for Mac 0
Finding the right style field in VBA 0
A very peculiar One Note problem 1
Corrupt? Scrolling while viewing two pages side by side, pages go wonky? 0
Images are pixelated when saving to PDF 0
Wrapping and Anchors 0

Top