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
Find plural word (with 's) and replace without ('s)
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Find plural word (with 's) and replace without ('s)
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Find plural word (with 's) and replace without ('s)
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
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78493
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Find plural word (with 's) and replace without ('s)
I doubt that it can be done in the Replace dialog. It should be possible in a macro, using Regular Expressions.
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Find plural word (with 's) and replace without ('s)
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.
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 4StarLounger
- Posts: 508
- Joined: 17 Dec 2010, 03:14
Re: Find plural word (with 's) and replace without ('s)
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".
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]
[Fmr MS MVP - Word]
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Find plural word (with 's) and replace without ('s)
TX Paul.
Agreed. I'll pass on the advice.
Agreed. I'll pass on the advice.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.