Find plural word (with 's) and replace without ('s)

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Find plural word (with 's) and replace without ('s)

Post by Rudi »

Hi,

How do I use Find/Replace to find variations of "operation" (including versions like: "operation's") and replace with "Cape Town".

In other words, I don't want "Cape Town's"

TX
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Find plural word (with 's) and replace without ('s)

Post by Rudi »

With some experimentation it seems that the "Sounds like" option in "More >>" does the job.

It changes variants like:
Operation
Operations
Operation's
Operational

But not:
non-operational

Is there a formula I can use to guarantee that all single-word forms of "operation" are changed?

TX
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
HansV
Administrator
Posts: 78369
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Find plural word (with 's) and replace without ('s)

Post by HansV »

I doubt that it can be done in the Replace dialog. It should be possible in a macro, using Regular Expressions.
Best wishes,
Hans

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Find plural word (with 's) and replace without ('s)

Post by Rudi »

Oh. OK.

I don't think we have to go to this extent for now, (barring additional assistance needed by the person who requested the advice.)

TX.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
macropod
4StarLounger
Posts: 508
Joined: 17 Dec 2010, 03:14

Re: Find plural word (with 's) and replace without ('s)

Post by macropod »

You could use a wildcard Find/Replace, where:
Find = [Oo]peration*>
Replace = Cape Town

That said, "Cape Town's" isn't necessarily wrong. Aside from being a possessive form - not a plural (the plural possessive would be Cape Towns') - it's perfectly acceptable to refer to, say, "Cape Town's population".
Paul Edstein
[Fmr MS MVP - Word]

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Find plural word (with 's) and replace without ('s)

Post by Rudi »

TX Paul.

Agreed. I'll pass on the advice. :cheers:
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.