Parsing Names
This one’s for Ron, who posted a comment yesterday. If you have names in various forms like
First Last
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.
J-Walk has one, too, called ExtractElement, that works well. See http://j-walk.com/ss/excel/tips/tip93.htm