Extracting UTM parameters from URLs

[anpassung]

Hello,

I am trying to extract the UTM parameters from my Google Analytics URLs with a formula in Excel. I looked on the forum & online but the solutions are for only 1 parameter & I would like to extract them into different columns. Also, I would like JUST the parameter & not umm_xxx. Is there a way to do this? I can pull out what is after the = but my skills are limited to pull out the second or more parameters.

https://www.test.com/test?hp=header&utm_expid=.rv5U4323Tv-MgchhoEB9Dw.0&utm_referrer=

https://www.test.com/us/test?utm_ex...B9Dw.0&utm_referrer=https:643/www.google.com/

https://www.test.com/test?utm_

Thanks for any help,

Adj

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.