Searching multiple text strings/variables

In a macro, I have several text strings to which I have assigned variables and I want to search them all to see if:

1) any of the variables match specific text (e.g "apples and pears") and if so change that variable to alternative text (e.g. "oranges and lemons")

2) any of them contain an ampersand, and if so to change that to "and"

Obviously I could add a couple of If statements for each variable, but I presume there is a neat way to search them all at once. I have tried declaring an array and using a loop, but have no experience with this so could not get it to work.

Play with this:

Please Login or Register  to view this content.