Extracting text and cycling through multiple instances

With a couple of very minor changes to my macro that I posted a few weeks ago, (I was planning to include those changes in v1.1 of my macro) you can do everything with a single call to my macro, as follows. (I'm assuming you placed your data into a variable called LocalUserData, but you can use any variable you want.)

image

Basically it lets you specify the string " X ", (I just realized you wanted lowercase, which is easy to change) then splits every occurrence of " X " with a newline, then puts quotes around every line, then merges all lines, combining them with " OR ".

I'm not expecting you to download my filter macro and use it. I'm just showing that there are other interesting ways to solve your problem.

1 Like