Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,064
- Office Version
- 2016
- Platform
- Windows
Hi
I am trying to extract some data from a list of URLs, but NOT sure how to do it.
I have a list of urls in column A Sheet1. I can not work out how to write a code that would extract the bit in RED.
href="/s/ref=sr_in_-2_p_6_0?fst=as%3Aoff&rh=n%3A318949011%2Cn%3A%21319530011%2Cn%3A319535011%2Cp_6%3AA3DA3SWCURNAWD&bbn=319535011&ie=UTF8&qid=1600344355&rnid=401720011"
All the urls will be as the one above, I only need the red part. The list of urls will be dynamic
I would like the data to go in to Sheet1 Column B
Thanks in advance
I am trying to extract some data from a list of URLs, but NOT sure how to do it.
I have a list of urls in column A Sheet1. I can not work out how to write a code that would extract the bit in RED.
href="/s/ref=sr_in_-2_p_6_0?fst=as%3Aoff&rh=n%3A318949011%2Cn%3A%21319530011%2Cn%3A319535011%2Cp_6%3AA3DA3SWCURNAWD&bbn=319535011&ie=UTF8&qid=1600344355&rnid=401720011"
All the urls will be as the one above, I only need the red part. The list of urls will be dynamic
I would like the data to go in to Sheet1 Column B
Thanks in advance