Formula to move text to col - 4 Words

I have a process that i need to repeat on a regular basis during data cleansing and that is to separate each title/name in to it's own column. The list contains, first name, last name, and sometimes ...