Is it possible to use SUBSTITUTE (or some other method) using a list of inputs?
For example, my target cell contains the string
<tbody>
I love Apples, I hate Orange, my Banana, my Grape
</tbody>
and on another sheet I have a ranged list:
<tbody>
Apple
Red
Orange
Orange
Banana...