Complext text manipiulation - a nesting problem??

[Glenn Kennedy]

I have datasets that identify which bacteria have been isolated from food These lists come in, typically, three forms: starting with the name of the bacteria, or with one of several fixed-text strings preceeding the name of the bacteria.

For example:

Suspicion of Listeria monocytogenes in cheese
shigatoxin-producing Escherichia coli in cheese
Salmonella typhimurium in cheese

I can (using a separate equation to separately remove each potential leading string - UGH) get:

Listeria monocytogenes in cheese
Escherichia coli in cheese
Salmonella typhimurium in cheese

I can't nest this, however.

Finally,

I can isolate the name of the bacterium, as it always consists of two words, giving the desired result:

Listeria monocytogenes
Escherichia coli
Salmonella typhimurium

the way I do this ain't pretty, but it works.

can you help me go from:


Suspicion of Listeria monocytogenes in cheese
shigatoxin-producing Escherichia coli in cheese
Salmonella typhimurium in cheese

to

Listeria monocytogenes
Escherichia coli
Salmonella typhimurium

without having to use VBA, in one equation. Example attached.