How to crop a part of the URL using excel formula

Hello,

I am trying to find a way to crop a part of the URL using excel formula.

For example below is my URL
mysite.com/redirect?site=test&utm_content=my_test_content&headline=newfile&siteurl

And i would like to copy whatever is after the utm_content parameter only. So using this example, i should get "my_test_content" in a new cell.

Can someone help me with this please?

Thanks

i would like to copy whatever is after the utm_content parameter

What does that mean? What do you want to get when you crop the URL?

Try this...

=MID(A1,FIND("utm_content",A1)+11,100)

Originally Posted by 99problems

Not working for me.

You said:

copy whatever is after the utm_content parameter

mysite.com/redirect?site=test&utm_content=my_test_content&headline=newfile&siteurl

My formula returns:

=my_test_content&headline=newfile&siteurl

Which is what you asked for.

If that's not what you want then tell us specifically what you do want.

Maybe this...

=TRIM(LEFT(SUBSTITUTE(MID(A1,FIND("utm_content",A1)+11,100),"&",REPT(" ",100)),100))

Returns: =my_test_content

@Tony: that's why I asked the question. I thought like you but wasn't sure.

@99problems: please don't edit earlier entries. It changes the context of subsequent points and the thread doesn't make sense.

Not to step on toes here, but, taking both formulas that Tony kindly provided and making slight adjustment(s), they will return the
"my_test_content" that OP wants.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Edit* I was just trying things out with the formulas so there might be a reason/(s) that it wont work for every URL on the sheet.

You're welcome. Thanks for the feedback!