Problem using 'PROPER' with apostrophes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When using PROPER to capitalise text, how do you get "CAN'T" to become
"Can't" instead of "Can'T".
 
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)
 
You must log in or register to reply here.

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

Proper() function handling of apostrophe 2
Apostrophe Mayhew 1
add apostrophe to text in cell 3
beginner question re =PROPER(A1) command 5
Leading Apostrophe 3
Mortgage with Quarterly Capitalisation & Monthly Payments 7
Added apostrophes from VBA to Excel?? 4
Leading Apostrophe 14

Back
Top