When all names are single-word names (or there are only a couple of them), you can use Text to Columns option of Excel with space as delimiter. You get columns with names, columns with "and", and a lot of empty columns (one for every space). And then delete all abundant ones (checking before for names which need editing).