If I can have a helper column with this formula:
=MIN(IF(ISNUMBER(SEARCH($P$10:$P$12,[@[HTML BODY]])),SEARCH($P$10:$P$12,[@[HTML BODY]]),LEN([@[HTML BODY]])))
Then I could perhaps use this:
=MID($K10,[@Helper],FIND("<",$K10,[@Helper])-[@Helper])
If I can't have a helper column then it's pretty ugly:
=MID($K10,MIN(IF(ISNUMBER(SEARCH($O$10:$O$12,$K10)),SEARCH($O$10:$O$12,$K10),LEN($K10))),FIND("<",$K10,MIN(IF(ISNUMBER(SEARCH($O$10:$O$12,$K10)),SEARCH($O$10:$O$12,$K10),LEN($K10))))-MIN(IF(ISNUMBER(SEARCH($O$10:$O$12,$K10)),SEARCH($O$10:$O$12,$K10),LEN($K10))))
See attached.
WBD
Bookmarks