I am currently using the following code
I have set up a separate sheet with all of the find and replace values.
Please Login or Register to view this content.
However what I really need is for the macro to find the values anywhere in the cell and replace it eg.
France - FR and France/USA stays the same
France/USA - FR/USA