I am currently using the following code

Dim x As Integer
Dim FindString As String
Dim ReplaceString As String
Dim NumRows As Integer
With Sheets("FindReplace")
    .Activate
 NumRows = Range("A2", Range("A2").End(xlDown)).Rows.Count
  Range("A:A").Select
  For x = 1 To NumRows
     FindString = ActiveCell.value
     ActiveCell.Offset(0, 1).Select
     ReplaceString = ActiveCell.value
     ActiveCell.Offset(1, -1).Select

     With Sheets("Sheet 1")
        .Activate
        Cells.Replace What:=FindString, replacement:=ReplaceString, LookAt:=xlWhole, SearchOrder:=xlByRows, MatchCase:=False
        End With
     Sheets("FindReplace").Activate
  Next
End With
I have set up a separate sheet with all of the find and replace values.
However what I really need is for the macro to find the values anywhere in the cell and replace it eg.
Right now
France - FR and France/USA stays the same
Would like
France/USA - FR/USA
Ideas?
Thanks