Split list of names to separate columns

[jzuber]

I have a list of names loaded into one column. I need to split these into separate first, middle and last name columns.

Names are different lengths
Not all names have middle names

Any ideas? thanks for your help.

 

[DonkeyOte]

try

Data Text to Columns though you may have to move some surnames across from the second column which will be middle names...use space as delimiter.

 

[jzuber]

I tried this, but must be doing something wrong. It requires me to define where the split is and when I define the split for one row, it is applied to all rows.

What am I doing wrong?

Thanks so much for helping!

 

[jzuber]

Stop the horses! I tried it again and it worked. You're my hero.

Thanks for your help.