I have a column in a worksheet that is pasted from a template and I want to add some code into a module that runs down the column (C) and parses out the text that I don't want. i.e. "ITV", "ESPN" and some others.

I also want it remove any ampersands that are in between these text. Sometimes it may say "ITV & ESPN". Only removing ampersands when they are in between these words.

Thanks in advance.