Try this, however if Bernie says you need a VBA solution, I may not
understand the question. He is a pro of course.

In C1 enter this and pull down.

=SUBSTITUTE(B1:B15,$A$1,"")

HTH
Regards,
Howard

"FARAZ QURESHI" wrote in message
...
I have a list of cells containing text to be removed from a collection.
What
sort a formula would help to achieve an array matter like:

=SUBSTITUTE(A1,B1:B15,"")

with items in B1:B15 to be removed from text in A1?

Please help urgently.

Thanx!