Propercase can't handle apostrophys

When using Propercase on a company's name I get false output if there is an apostrophy in the string.  Example:  From Propercase({CompanyName})  on "JEFF'S FIRM" I get:  "Jeff'S Firm" instead of the assumed correct output: "Jeff's Firm"   Can anybody help with a workaround on this solution?  I tried Replace(Propercase([CompanyName]), "'S","'s"), however, it didn't work.  Any ideas?
randybdavisAsked:
Who is Participating?
 
frodomanCommented:
Are you certain that the apostrophe is really an apostrophe?  For example, could it be the accent mark that's normally under the tilde (~) on the keyboard?  Although in many fonts they look identical the ascii code for them is different so your replace won't find it unless you use the same accent character in your formula.

frodoman
0
 
frodomanCommented:
I'm surprised that what you tried didn't work because it does work for me - maybe a difference in versions.

   replace(propercase("Joe's Diner"),"'S","'s")

The above returns "Joe's Diner" exactly as you'd want.  You might want to try forcing the lower case conversion like this:

   replace(propercase({CompanyName}),"'S",lcase("'s"))



frodoman
0
 
randybdavisAuthor Commented:
Hi frodoman,

I used your code and this is the output:

Company Name (Lessee or Owner): Jeff`S Firm
0
 
randybdavisAuthor Commented:
Hey frodoman,

Congradulations,  you won!!!  It was that character under the tilde.

Thank you.  :-)
0
 
frodomanCommented:
You're welcome - glad I could help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.