Do Find & Replace multiple times using data in Col B for find & data in Col C for replace

You would need to set N = 8 in the first row of code. If you still have problems, I suggest posting a copy of the actual data as there may be some important detail that your description missed.