Extract Specific Text From String

[dawsexcel]

Hello,

I have a URL where I want to extract the specific text from part of the string, that text will differ in length but will always be between two points e.g.

https://www.example.com/uk/?src=ppc-g&med=c-d&cmp=exa-xxx-xx-xxxx&off=xxxx&lp=xx&client=xx-xx-xx-xx,{keyword}

The two sections are preceded by '?src=' and '&med=' and always finsihes at the ampersand that follows it, so above example it would extract 'ppc-g' & 'c-d'.

Any clever excel user out there who can help create a formula that does this, 1 formula for each data extraction is fine as i will put them in two separate cells (unless i can use the same formula twice)

Thanks!

[Jdevil]

=MID(S22,FIND("?src=",S22)+5,FIND("&",S22,FIND("?src=",S22))-(FIND("?src=",S22)+5))
=MID(S22,FIND("&med=",S22)+5,FIND("&",S22,FIND("&med=",S22)+1)-(FIND("&med=",S22)+5))

With S22 being whatever cell you have

[Olly]

Try:

Please Login or Register  to view this content.

Where your URL is in A1, and "?src=" or "&med=" is in B1.

[dawsexcel]

Great, worked a treat.

Thanks a lot!!