Cum să găsiți și să înlocuiți în masă

Sper că ceea ce sunt pe cale să întreb este posibil cumva. Fie că este vorba doar de Excel, Kutools pentru Excel, Power Query, or Power Automate. I'm open to all solutions right now.

I shot this video that has details to make it easier to understand:

[video]https://p123.p4.n0.cdn.getcloudapp.com/items/ApuXbWWR/39f4f364-38c8-4d93-9d2d-8aa13322c913.mp4[/ Video]

Dar iată elementele de bază:

1. I have a list of 8700+ keywords but I want to know how many times the keywords with locations show up.
a. For example, these three keywords are pretty much the same:
i. land for sale in Arizona
ii. land for sale in Texas
iii. land for sale in California
b. And so I would want to know the “land for sale in” shows up three times
2. So, I need to Find and Replace all the States within all the keywords with “[TOKEN]”
3. Then, I need to Find and Replace all the Counties within all the keywords with “[TOKEN]”
4. Finally, I need to Find and Replace all the Cities within all the keywords with “[TOKEN]”

I hope this makes sense and that there’s some way to do this.