[RizzKid]

Office 2007. I'm doing a mailmerge using an Excel spreadsheet via OLE. I've
got a field that contain's a person's name, and am trying to find an easy way
to deal with text in the possessive form. For example:
{ MERGEFIELD Person }'s belongings
generates
Bill's belongings
Morris's belongings
etc. The problem is that I'd like "Morris's" to become "Morris'". If I could
just test for RIGHT({ MERGEFIELD Person },1)="s" that would do the trick. But
I can't find any way to do it. Of course I could accomplish this in Excel and
pass another field to Word, but I'm trying not to.