Gurus,

I have a column of full names, and each entry in the column could look like one of these:

lastname, firstname middlename
lastname, firstname
lastname, firstname middleinitial
hyphenated-lastname, firstname
hyphenated-lastname, firstname, middleinitial
hyphenated-lastname, firstname, middle name
firstname lastname
firstname middleinitial lastname
firstname middlename lastname
firstname secondname middlename lastname
lastname suffix, firstname middlename
lastname suffix, firstname
lastname suffix, firstname middleinitial
hyphenated-lastname suffix, firstname
hyphenated-lastname suffix, firstname, middleinitial
hyphenated-lastname suffix, firstname, middle name
firstname lastname suffix
firstname middleinitial lastname suffix
firstname middlename lastname suffix
firstname secondname middlename lastname suffix

I know; my client has a problem standardizing their data...

So, what I need, at the end of the day, is firstname secondname in the original column, and lastname suffix in the next column. All of the middlenames or middleinitials can be stripped.

I envision selecting the name column cells (they vary in number) and running a VBA macro that I've added to the command ribbon.

Super appreciate any help!