 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Chat Forum
2
Posts
2
Users
0
Reactions
36
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