This one’s for Ron, who posted a comment yesterday. If you have names in various forms like
First M. Last
First Last, Jr.
and you need to split them apart, then you need some text manipulation functions. I can’t explain it any better than Chip Pearson on his Extract First and Last Names page, so I refer you there.