How to mass Find and Replace

[mrstoked]

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:



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.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to mass Find and Replace
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.