Finding second instance of a word in a string --

[Bill Roberts]

Greetings,

I import names and addresses into a database for mailing lawn care offers. I get the data from various county administered tax rolls. I can specifically target particular neighborhoods.

The data is different in the various counties we serve. The homeowner names are in various formats. When there is an "&" between the husband and wife names, I can split the data there and come up with "Jack & Jane Doe" fairly easily. Where I am having an issue is when the name data is more jumbled.

So here is an example of cell with the name data:

[TABLE="width: 425"]
<tbody>[TR]
[TD="width: 425"]KATHY J STEPHENS STEPHENS WILLIAM T

the result I want is

KATHY & WILLIAM in one column and STEPHENS in a second column.

I could do a "text to column" and split the data into cells and then somehow compare each column to find two instances of the last name and use that to come up with the result.... ??

Sometimes the data may only be one person or 2 people with different last names. In the case of the latter, one person's name is fine. Here are some examples.

[TABLE="width: 425"]
<tbody>[TR]
[TD="width: 425"]JUAN DIAZ
[TABLE="width: 425"]
<tbody>[TR]
[TD="width: 425"]RONDA D RINGO[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 425"]
<tbody>[TR]
[TD="width: 425"]ROBERT STEWART BOYD JOHNSON BRITNEY JOY[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Ok, maybe I am rambling now. Any help to push me in the right direction is appreciated.

Thanks,
Bill Roberts
King Green [/TD]
[/TR]
[TR]
[TD="width: 425"][/TD]
[/TR]
</tbody>[/TABLE]