macro to split names people part 2

Question: Hi Experts

Need a macro to split the first name and surnames of people according to the following rules:

1. If column A2 onwards has a person name as Joe Mark Robinson and a blank cell in column B2 so you would see the following in a excel worksheet

Column A2                           Column B2
Joe Mark Robinson               empty cell (THEN DO THE FOLLOWING)

Joe Mark                              Robinson (surname only)

(first name & Middle name or initial) - if no middle name then or initial then first name ONLY

The opposite to the folllowing macro:-

https://www.experts-exchange.com/questions/25094375/macro-to-split-name-s-people-data.html