Extract data from a List of URLs

[Sharid]

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

 

[DanteAmor]

You could put other examples.
Use the XL2BB tool to paste a range of cells here.

If the text to extract is always before the second "&" symbol and it is always 14 characters, then you could try the following:

Libro2
	A	B
1
2	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"	A3DA3SWCURNAWD
Hoja3

Cell Formulas
Range	Formula
B2	B2	=MID(A2,FIND("&",A2,FIND("&",A2)+1)-14,14)

 

[sandy666]

with Power Query

source
A3DA3SWCURNAWD

let
    Source = Excel.CurrentWorkbook(){[Name="Table23"]}[Content],
    TBD = Table.TransformColumns(Source, {{"source", each Text.RemoveRange(Text.BetweenDelimiters(_, "%", "&", {0, RelativePosition.FromEnd}, 0),0,2), type text}})
in
    TBD