Hi Everyone,

I've researched to the point of needing help now. Any help would be appreciated.

I have a column that is called Options with a string of words (a chunk of HTML really). In this column I want to parse through each cell and look for each of the following variables:

Draw Hand: (Right,Left)
Draw Weight: (x)
Draw Length: (in half inches)
Arrow Length: (in half inches)

If any of those variable strings are in the cell, then I want them placed in a separate column in the spreadsheet.

Spreadsheet here at Google Docs:

I would ideally like to have a VBA script that is flexible to add more variable strings as needed. Many thanks for your help!

Kind Regards,
Justin