muiltiple find and replace for changing data

[sazloolabean]

Hi There,

I am looking for a solution to an odd excell problem I have.

I will have ever changing lists of names but withing that list will be ones that will always need changing. Is there a way to find a replace the same names from a list every time I paste it into excel?

So for example, I have a list every day for 3 days of llist of 500 different names but every day I need to find and replace the same 50 names as they will appear in those lists and be wrong. I nkow how to do find and replace singular but if I can do it as one instead of multiple searches that would be better.

Any ideas?

Thanks

[Palmetto]

You can start with this link, which provides an answer to a similar question.

Array Replace Code