Using A2007. I want to separate first and last names into separate first and last name fields. I can make a name like "Joe Smith" into two fields; Smith and Joe But how do I separate a name that is entered as "Joe and Mary Smith" or "Joe & Mary Smith" or " Joe Michael Smith" into Smith in the last name field and the other names in the first name field? Any help much appreciated.