This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
If you are assuming that the only possible name formats are the ones shown in your screenshot, you could use the text to column tool and split on spaces (\s). If there is only a first name listed, this will the first name column and leave the other two blanks. Additional logic would need to be implemented if a name without a middle name was inputted.