![]() |
|
#1
|
||||
|
||||
![]()
Robert:
Audioman probably wants to change strings like: "apples, oranges, peaches" to: "apples, oranges and peaches" not merely the literal "apples, oranges, peaches" string to: "apples and oranges and peaches" and to change other instances like: "apples, oranges" to: "apples and oranges" but your Find/Replace code won't do any of that. It is also quite likely there will be many other commas that shouldn't be replaced - as in the one used in this sentence. Audioman: Although a macro could be written, the level of interactivity required would scarcely make it any more efficient than using a non-macro Find/Replace where you selectively choose whether to replace a given comma with ' and'.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#2
|
|||
|
|||
![]()
You're right macropod. I was using apples, oranges, peaches as an example. The document will actually contain people's first names and, of course, the names will vary. Someone gave me a macro a couple of years ago and it worked perfectly. Unfortunately, shame on me, I need it again and I can't find it.
|
![]() |
Tags |
find & replace, macro in word, office 2010 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Error: "Changes made were lost...reconnect with server", when switching "from" field | randhurrle | Outlook | 2 | 02-25-2015 06:51 PM |
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas | jocke321 | Word VBA | 2 | 12-10-2014 11:27 AM |
![]() |
DHammer | Mail Merge | 1 | 05-30-2014 02:43 AM |
How to edit the "Format" and the "show level" of an EXISTING table of content? | Jamal NUMAN | Word | 2 | 08-14-2011 10:46 AM |
![]() |
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |