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

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:

> Proper
>
> Capitalizes the first letter in a text string and any other letters in text
> that follow any character other than a letter. Converts all other letters to
> lowercase letters.


In article <78CD474C-12D0-4293-A217-A6C2E0ED42FD@microsoft.com>,
Josh Ross <Josh Ross@discussions.microsoft.com> wrote:

> The proper function incorrectly capitalizes the letter after an apostrophe.

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