Multiple Find and Replace

[Tigerexcel]

A common task in Excel is to update product codes, status etc. What is your preferred/quickest method to do this? I should explain that I'm talking multiple entries at the same time eg ABC to become ABC1, DEF to become DEF1 etc. The replacement information to change will vary and so hard-coding is not really an option.
I've seen VBA methods for doing this but my VBA skills are still basic and I can cope if there's not too much code and it's kept pretty simple. Is there perhaps another way using functions or some other means?

 

[My Aswer Is This]

Your code is fine but I will have to set this up for others whose Excel skills are not strong. I'm happy to go with the macro for myself and will most likely use it for others, just wondering what alternatives are there, if any.

I have no easier answer. Do you have a easier ideal?

 

[Tigerexcel]

I have no easier answer. Do you have a easier ideal?

Not really, we were discussing this at work. Someone mentioned that you could use the SUBSTITUTE function but it would involve a degree of nesting which renders it more difficult.