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.
Right now
France - FR and France/USA stays the same
Would like
France/USA - FR/USA
Ideas?
Thanks
Bookmarks