Split a single field into multiple specific columns

Breaking up a list of names into First Name, Middle Name & Surname.  In this exercise we cannot simply use text to column because the data may contain a First Name and Surname only OR a First Name, Middle Name and Surname.  The objective is to get the data in the correct column.

After doing this video I thought of at least 3 other methods to doing this including for example counting the spaces between the words and having a conditional loop that puts the last entry in the last column if there are 2 or three words in the phrase, the first in the first column and only handle the second column if there are 3 words. 

This shows that in Excel there is always many ways to skin a cat, and my methods demonstrated, is by no means the ONLY practical methods.