Find similar town names in Excel [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
What if the similiar towns are actually two towns
example

Farmington
Farmington Hills

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!