Find similar town names in Excel

Closed
Josh - Jun 4, 2010 at 07:59 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 4, 2010 at 08:32 AM
Hello,

I have a list of towns in Massachusetts.

I want to combine similar towns into one entry, so for instance, Brookline and Brookline Village and Newton and East Newton would be combined into just Newton and Brookline.

All of the towns are in one column.

What's the best way to do this?

Thanks,
Josh


Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 4, 2010 at 08:32 AM
What if the similiar towns are actually two towns
example

Farmington
Farmington Hills