Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 04 August 2022
  0 Replies
  2.3K Visits
0
Votes
Undo
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.
There are no replies made for this post yet.