If you have multiple middle names, you can use the same formula mentioned above to separate the first and last names, but you will need to repeat the process for all the middle names.