Finding second instance of a word in a string --

Bill Roberts

New Member
Joined
Aug 7, 2019
Messages
3
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:

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.

JUAN DIAZ
RONDA D RINGO

<tbody>
</tbody>
ROBERT STEWART BOYD JOHNSON BRITNEY JOY

<tbody>
</tbody>

<tbody>
</tbody>

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

Thanks,
Bill Roberts
King Green

<tbody>
</tbody>
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Forum statistics

Threads
1,213,510
Messages
6,114,040
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top