Hello,

I have an excel assignment and i am wondering if someone could help me out.

Here is my task:

In Column A there are long URLs with keys and values.

For example: http://ad.doubleclick.net/adj/active...ture2=nosubfea ture2;subfeature3=nosubfeature3;sz=728x90;position=leader_top;dcopt=ist;eventid=;eventlisting=;country=;state=;typeid=;g ender=ng;age=;skill=;traveler=n;demo_a=;estate=;etype=;esubtype=;ezip=;assetid=4e2fe191-1d0d-4b90-9d6d-8dc9b1c03717;dest_dma=;view=running;ord=845674?

This URL has many keys and values one of which would be channel = running (see bold above)

My task is to create a formula that extracts certain keys and values in each URL. Please note that some of the keys and values will be different for other URLs.

Channel Subchannel subfeature1
http://ad.doubleclick.net....etc



So looking at the above table, I would need to come up with a formula in B2 that will provide the Key(Channel) and the Value(running) for the corresponding URL.

Also, the best solution will allow me to change the key in B1(Channel) to any other key and it should dynamically populate the values in the below rows.

Your help is greatly appreciated!

Thank You