Find and replace script / macro?

Thank you for the code. I'm going to try it out asap!

Ok, this is a really really stupid question I know. I am a total beginner to excel. How do I implement this code? I'm using excel 2007.

*Sigh*, very sorry about this question

Hi Simon,

Thank you very much for the help. Sorry for the late reply, I fell ill a few days.

I tried out the script and it appeared to work perfectly for small sample size of my spreadsheet.

However, when I tried to use it for my entire large spreadsheet of 21,000 items, a strange thing happened. It took several hours(!) to run and when it completed it replace many of the data in Column C with '~' when it should not have.

Very strange...


Example item:

Original item:
等-----------děng-----------v. wait | Qǐng děng yīhuǐr. Please wait a minute. ◆b.f. ①class; grade (頭等 tóuděng attr./n. first class/rate) ②be equal (平等 píngděng s.v. equal ; n. equality)


Replaced item should be:
等-----------děng-----------v. wait | Qǐng ∼ yīhuǐr. Please wait a minute. ◆b.f. ①class; grade (頭∼ tóu∼ attr./n. first class/rate) ②be equal (平∼ píng∼ s.v. equal ; n. equality)


Resulting output:
等-----------děng-----------v. w ~ it | Qǐng ∼ yīhuǐr. Ple ~ se w ~ it ~ minute. ◆b.f. ①cl ~ ss; gr ~ ~ (頭等 tóuděng ~ ttr./n. first cl ~ ss/r ~ te) ②be equ ~ l ( ~ 等 ~ s.v. equ ~ l ; n. equ ~ lity)



hmmm...

I'm not sure why this happened, but is there a way to fix this?

Yes, it's supposed to replace the items in column C, however it is replacing the wrong items.


It is replacing with the Resulting output (in column C) is:
等-----------děng-----------v. w ~ it | Qǐng ∼ yīhuǐr. Ple ~ se w ~ it ~ minute. ◆b.f. ①cl ~ ss; gr ~ ~ (頭等 tóuděng ~ ttr./n. first cl ~ ss/r ~ te) ②be equ ~ l ( ~ 等 ~ s.v. equ ~ l ; n. equ ~ lity)


but the replaced item in column C should be:
等-----------děng-----------v. wait | Qǐng ∼ yīhuǐr. Please wait a minute. ◆b.f. ①class; grade (頭∼ tóu∼ attr./n. first class/rate) ②be equal (平∼ píng∼ s.v. equal ; n. equality)


I'm not sure why this is happening. In small excel file with a few rows the macro works without any problems, but for my spreadsheet of 21,000 items, almost all of the replaces in Column C is replaced incorrectly.

Hi Simon,

I have included a sample of my excel worksheet. The original file is about 11mb, so I only included 100 items. The original and the output.

If it is not enough please let me know, I can provide more examples, if you need the whole worksheet, I can email that you to you also.

Thank you for your help!