Need to pull all strings that start with <> and...

I am trying to write a macro that will go through an Excel Range called "Predecessors" and identify any phrases in the field that begin with <>. The cell will look something like:

111,<>\NCAL ICD-10 Reporting And Analytics - AMB\111,<>\NCAL ICD-10 Reporting And Analytics - AMB\108,<>\NCAL ICD-10 Reporting And Analytics - AMB\112

Next I need to pull that phrase (between two commas) out and write it to a new list along with the Project Name and the % Complete fields.

I picture the logic something like:

You are working through an excel worksheet that has three columns: Project, % Complete and Predecessors

Store Project Name in variable
Go through Predecessors data until project name changes
As go through, parse out every phrase in the Predecessor field that begins with <>
For each phrase found, Write out Project Name, Predecessor phrase and % Complete creating a new dataset on same worksheet
Check for change in Project Name, if not, Next Predecessor
If Project Name has changed then got back to store project name in variable.
Go back to check if Project Name has changed.