I have a workbook with URLs and I need to extract each key value pair, with only the value listed in subsequent columns. I am having problems creating the correct formulas and would greatly appreciate some help! I understand where the key value pairs are & what I'm looking for, just not how to extract them. Also, I should be able to use the same formula for A1:H19 for it to be considered correct. Looks as follows: URL http://ad.doubleclick.net/adj/activecom.tan/running/content;tile=1;channel=running;subchannel=nosubchannel;tanproduct=activecom;b2borb2c=b2c;feature=content;subfeature1=channel_home;subfeature2=nosubfeature2;subfeature3=nosubfeature3;sz=728x90;position=leader_top;dcopt=ist;eventid=;eventlisting=;country=;state=;typeid=;gender=ng;age=;skill=;traveler=n;demo_a=;estate=;etype=;esubtype=;ezip=;assetid=4e2fe191-1d0d-4b90-9d6d-8dc9b1c03717;dest_dma=;view=running;ord=845674? Columns Channel Subchannel Feature Subfeature 1 Subfeature 2 Subfeature 3 Position Thanks, BMW87

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Extracting values in excel 2013

Thread starter BMW87
Start date May 25, 2014

BMW87

New Member

May 25, 2014

I have a workbook with URLs and I need to extract each key value pair, with only the value listed in subsequent columns. I am having problems creating the correct formulas and would greatly appreciate some help! I understand where the key value pairs are & what I'm looking for, just not how to extract them. Also, I should be able to use the same formula for A1:H19 for it to be considered correct.

Looks as follows:

URL
http://ad.doubleclick.net/adj/activ...c9b1c03717;dest_dma=;view=running;ord=845674?

Columns
Channel
Subchannel
Feature
Subfeature 1
Subfeature 2
Subfeature 3
Position

Thanks,
BMW87

Last edited: May 25, 2014