Working w/ contracting/quotes, etc. "CONTRACTOR SHALL" statements and want to be able locate the word that follows the statement "Contractor Shall" in every line then copy/paste that single word into either Col A or C (whichever is easiest programmatically).. My example shows it in Col A.

So, when it's done, it will look like the attached image: (and like statements can be grouped)

Name:  shall-stmts.GIF
Views: 218
Size:  44.8 KB