Full name: Major, Kathleen
First Name: Kathleen
Surname: Major
Full name: Paul and Mary St. John
Contact 1: Paul St. John
Contact 2: Mary St. John
Full name: Lt. Col. John J. Smith, III
Honorific: Lt. Col.
First Name: John
Middle Name: J.
Surname: Smith
Suffix: III
 
I have two contact names in one field. Can I split them out into separate columns?
Answer
Yes. If your table contains a field with multiple contact names, e.g. "John Smith and Patricia Jones", each full name can be parsed into separate contact columns. Have a look at Full Name Parsing Part 2 to see how easily this can be accomplished.