Pulling specific number of words after each space

[Weeman656]

So I have a problem I am trying to create an excel sheet and a client has submitted it in the wrong format I need the last names of each person in each group and he submitted it( example below) I was wondering if there is an easy way of pulling each word after each space so I can grab every last name on a list of over 7000. Each name is in that format on each row. Any help would be appreciated!
Bob Smith/Paul George/Peter Parker

 

[Rick Rothstein]

Bob Smith/Paul George/Peter Parker

Please clarify... are those three names in a single cell with a slash between them or is each name in its own cell? If the latter, are those individual names across a single row or down a single column?

 

[Weeman656]

To clarify they are each in a row exactly like that format usually two or three people in that format in each row so like below in each cell peter/bob being cell one
Peter Parker/Bob Smith
Joe John/Bill Bob/Mike Joe