Quote Originally Posted by pwyller View Post
Sorry, you missed the point. With a comma, the last name is always first (with or without suffix), followed by the first name and initial or another name. Without a comma, it is always first name first, middle or second name(s), and last name (with or without suffix). The examples I provided are all inclusive and define the rule sets.
Hi,

But that explanation only deals with three name parts (first name first, middle or second name(s), and last name) plus a suffix if applicable. In your data you also have firstname secondname middlename lastname suffix, i.e. four name elements plus suffix.

We often find that when we give an answer to what is a trivial non representative example, when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy) as requestes, and manually add the results you expect to see.