Microsoft Office Forums - View Single Post - [Solved] How to find&replace several items at once?

macropod · 11-29-2013, 08:58 PM

OK, now that I can see what you have, you could use a macro like:

Code:

Sub BulkFindReplace()
Application.ScreenUpdating = False
Dim FList As String, RList As String, j As Long
FList = "¸|î|å|?|®|ß"
RList = "Ç|é|ä|ë|å|ñ"
With ActiveDocument.Range.Find
  .ClearFormatting
  .Replacement.ClearFormatting
  .Format = False
  .Forward = True
  .MatchCase = True
  .MatchWholeWord = False
   'Process each item from the Find/Replace Lists
  For j = 0 To UBound(Split(FList, "|"))
    .Text = Split(FList, "|")(j)
    .Replacement.Text = Split(RList, "|")(j)
    .Execute Replace:=wdReplaceAll
  Next
End With
Application.ScreenUpdating = True
End Sub

Note that every entry in the Find list (FList) must have a corresponding entry - even if empty - in the Replace list (RList)