Dear all
I am using a find and replace macro to change country abbreviations to an internal code.
Here's my problem though (please see code below).
Columns("I").Replace What:="RU", Replacement:="1MOW"
Columns("I").Replace What:="BE", Replacement:="1BRU"
This is one example which messes things up for me.
I want Belgium (BE) to change into 1BRU and Russia (RU) to change into 1MOW.
However, once BE changes to BRU (now including the letters RU), the macro runs again and changes 1BRU to 1B1MOW.
How can I fix that?
Thank you!
Bookmarks