![]() |
#5
|
||||
|
||||
![]()
Try:
Code:
Sub Demo() Application.ScreenUpdating = False Dim Rng As Range With ActiveDocument.Range With .Find .ClearFormatting .Replacement.ClearFormatting .Text = "<[A-Z][! ]@, [A-Z][! ]@>" .Replacement.Text = "" .Forward = False .Wrap = wdFindStop .Format = False .MatchWildcards = True .Execute End With Do While .Find.Found If Len(.Text) > 1 Then Set Rng = .Duplicate .MoveEndUntil ",", wdBackward .Start = .End - 1 .Text = " and" With Rng .Collapse wdCollapseStart Do While .Characters.First.Previous.Previous = "," .Start = .Start - 3 .Start = .Words.First.Start If Not .Characters.First Like "[A-Z]" Then .Collapse wdCollapseEnd Exit Do End If Loop End With .Start = Rng.Start .Collapse wdCollapseStart .Find.Execute Else Exit Do End If Loop End With Application.ScreenUpdating = True End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
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 |