Note: The other languages of the website are Google-translated. Back to English
  Thursday, 04 August 2022
  0 Replies
  1.1K 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.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL