Hey guys. I'm trying to extract first AND last names from a string of text(4000+ rows) and have them copied to a separate cell. The idea is that I can search the text for the first name then simply copy that name and the following string(likely last name).

Anyway, it's not as easy as I thought. Here's what I have so far.... 
{=IF(COLUMNS($C68:F68)<=$B68,INDEX(KEYWORDS,SMALL(IF(ISNUMBER(FIND(" "&TRIM(KEYWORDS&" "," "&SubText&" ")),ROW(KEYWORDS)-ROW(INDEX(KEYWORDS,1,1))+1),COLUMNS($C68:F68))),"")]}
I have a list of common names on Sheet2 that the function checks against.

If possible I'd like to copy multiple names. The following is an example strong of text...

Additional information
MSP #29 William Nelson Pres Jessie Nelson Member; Sr V Pres Amber Cave Administrative Assistant
So for that line I'd like to extract "William Nelson" "Jessie Nelson" "Amber Cave", each in separate cells


Thanks ahead of time. This is hurting my brain.