software

It'S Just My 2-Cent'S Worth, But I Think
Excel'S Proper() Function Does A Bad Job With Its
Handling Of Contractions And Possessives. For A 2nD
Example, Look What It Does To 2Nd And 3Rd!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions

quot;RPellessierquot; gt; wrote...
gt;It'S Just My 2-Cent'S Worth, But I Think
gt;Excel'S Proper() Function Does A Bad Job With Its
gt;Handling Of Contractions And Possessives. For A 2nD
gt;Example, Look What It Does To 2Nd And 3Rd!
....

There are work arounds for contractions and possessives,

=TRIM(SUBSTITUTE(SUBSTITUTE(PROPER(x)amp;quot; quot;,quot;'S quot;,quot;'s quot;),quot;'T quot;,quot;'t quot;))

As for ordinals, no easy fix without regular expressions, but you kinda
deserve this problem for not using Second or Third.