Extracting UTM Parameters from URL

[shlomo365]

I need to extract the campaign parameter from a set of URLs with UTM parameters. Here's an example.
http:/example.com/&utm_source=Web+Campaign&utm_medium=AccountBudget&utm_campaign=More_subscribers_6_14_17
What I need is an Excel formula that will take this URL as an argument and have as the cell value: More_subscribers_6_14_17

 

[Special-K99]

Test data should consist of more than one example, since you can't determine a pattern from just one element of data.

So this works on your one example.

=RIGHT(A1,LEN(A1)-FIND("utm_campaign",A1)-12)

 

[shlomo365]

Works beautifully. Thank you.