Macro to Parse String

Hello, I REALLY need help soon! I have an Inventory Excel Spredsheet where i need to parse the data in a column. I need to create a Macro to do this. I have to parse this data into 'First Name' , and 'Last Name' (I ONLY NEED THE NAMES, all other data is irrelevant) and does not have to be parsed but my data does not only contain names so i just can't just parse where there is a space or colon. If there is a "Jr' or 'II' or any other name after the last name, it should be grouped with the 'Last Name', all other data (room numbers) after the last name can be in a seperate column. My data looks similar to this:

Column A
ND
ND
Assigned: Jim Scott Jr - Rm 279
Assigned: Joe M Smith - Rm 990
ND
ND
Stored: Room 432
Extra: Room 123
Assigned: Tony Tone II - Rm 356
Assigned: Susie Q Young -Rm 394
Stored: Room 563
Stored: Room 789
Extra: Room 654
ND
Assigned: Jimmy Joe Jr - Rm 276


Please let me know if you need any questions answered! I am on a tight deadline so any start will help! Thanks so much in adavnce!