The proper() function makes sam's Sam'S.

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

Guest

The proper function incorrectly capitalizes the letter after an apostrophe.

Language US-EN 1033
 
Actually, it's correct, if not what most people would want. Then again,
XL is not a word processor. As documented in Help:
 
One way to trick it would be to use something like

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


Regards,

Peo Sjoblom
 

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
trying to change Proper function results to text? 1
LEFT and PROPER 5
Help w/ the PROPER function 2
Serious Sam HD - Legend Of The Beast DLC 1
Serious Sam 3: BFE 6
How to format text 'exactly' as entered. 3
TRIM function 6

Back
Top