MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Chat Forum
2
Posts
2
Users
0
Reactions
38
Views
Topic starter
Hello,
I have a spreadsheet with 1500 URLs in it that have been extracted from an SEO crawl tool.
Some of the URLs point to English pages, and some to Chinese pages. The URLs are messy, but some have either EN or ZH language codes deep in the URL string. Sadly they have not been applied consistently.
I need to separate the two languages out - I assume VLOOKUP is the way, but I am at best clumsy with Excel.
How should I approach this to avoid manually considering every URL and pasting it to a new sheet individually?
Thank you.
Posted : 29/03/2018 3:14 pm
Posted : 29/03/2018 3:17 pm
Topic starter
Murray, my man! Thank you! That looks to have done the trick 🙂
Posted : 29/03/2018 3:25 pm