Mutiple replace function/macro?

[CatAstrophy]

Is there a way I can run a function or macro to do several replace commands in bulk?

Made up example

Replace all occurrences of General||| within a field with "" (blank)
Replace all occurrences of Misc||| within a field with "" (blank)
Replace all occurences of Anything||| within a field with "" (blank)
etc...

all in one press of a button (of course, I'd need to set it up first)

I have many many sheets this needs to be applied to and running a plethora of replace commands manually is very tedious. I'm assuming there's a macro for this but I know nothing about programming. I just copy and paste pre-made macros and edit the appropriate parameters.

Anyone have one that I can use?

Also I noticed that for some weird reason I can't always replace text with "" (blank). Sometimes it works, sometimes it only replaces the pattern (color). Fields are colored in red and after a replace function get colored in white to show they are done.

Thanks in advance!

[CatAstrophy]

this is in Excel 2003