Extract URL Parameter using Excel Formula

Question

How can I extract the URL parameter "kw" from this URL using an Excel formula?

http://www.googleadservices.com/pagead/aclk?sa=L&amp;ai=CJUQ7zvAbVdK_CrHSsQf6iIHYD7zV59kHvJfs5LABpuWU_AMIABABKANgofiHgGygAbz01eADyAEBqQK8TgDDlm9-PqoEKE_QrRjDXKCZneohUov47wCTKVWTFGDo-TbcFZnV3yZ1YGhvXWUb_WuIBgGAB6yLqh-QBwOoB6a-G9gHAQ&amp;ohost=www.google.com.ar&amp;cid=5GhbrxlB07mO7bZOlKEDRYCN1cvrdfvVgL6nRn6sDtpHjLQ&amp;sig=AOD64_1lIeXRqqfwLyHYFCfMWeYn0n0N6Q&amp;rct=j&amp;q=&amp;ved=0CBkQ0Qw&amp;adurl=http://segurosendirecto.com.ar/cotizador-de-seguros-auto?kw=san%2520cristobal%2520seguros

Please show what you have tried so far

Rohit Gupta
– Rohit Gupta

2015-07-18 00:09:56 +00:00
Commented Jul 18, 2015 at 0:09 — Rohit Gupta
– Rohit Gupta, Commented Jul 18, 2015 at 0:09

pnuts · Accepted Answer · 2015-07-18 00:27:50Z

2

With the URL in cell A1, use:

=MID(A1,FIND("kw=",A1)+3,9999)

enter image description here

and if you want to include the wk=, just drop the +3 from the formula.

edited Jul 18, 2015 at 0:27

pnuts

59.7k11 gold badges92 silver badges141 bronze badges

answered Jul 18, 2015 at 0:15

Gary's Student

96.9k10 gold badges66 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

siguientenivel Over a year ago

not working in excel 2010, says formula contains an error

Collectives™ on Stack Overflow

Extract URL Parameter using Excel Formula

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related