Hopefully, what I'm about to ask is possible somehow. Whether it's with just Excel, Kutools for 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]

But here are the basics:

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.