Microsoft Office Forums - View Single Post - [Solved] Delete Character on Single Line Only

macropod · 04-18-2017, 03:58 PM

Try:

Code:

Sub Demo()
Application.ScreenUpdating = False
With ActiveDocument.Range
  With .Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Forward = True
    .Wrap = wdFindContinue
    .Format = False
    .MatchWildcards = True
    .Text = "[ ]{4}|Z|"
    .Replacement.Text = "ZR"
    .Execute Replace:=wdReplaceAll
    .Text = "|"
    .Replacement.Text = ""
    .Execute Replace:=wdReplaceAll
    .Text = "[ ]^13"
    .Replacement.Text = "^p"
    .Execute Replace:=wdReplaceAll
  End With
End With
Application.ScreenUpdating = True
End Sub

On my laptop, with 10,000 records to process, execution takes just 21 seconds.