Split URL after certain text

[lavezzi7]

Hey guys,

I have a couple of URLs that contain the "origin?" text before the part I want to extract. For example:

wwwXXXX.com/ie-de/origin=10_se_Display_native
wwwXXXX.com/ia-de/de/origin=10_se_Display_on
wwwXXXX.com/ia-it/de/origin=10_se_Display_off

I want to create a new column containing the text after "origin=". In this case the new column should contain:

10_se_Display_native
10_se_Display_on
10_se_Display_off

Is there a formula to automatically get that? Please note that neither the part I want to get nor the other part has the same amount of characters among the URLs so I cannot use position-related formulas.

Any kind of help would be very much appreciated!

Thank you in advance!

 

[philwojo]

Your link doesn't work for me and most of the time I am blocked form those at work.

Can you please just copy and paste in to here exactly what you are inputting in to excel.

 

[lavezzi7]

it does not have to work, i need the part after origin= in a new excel column.

 

[philwojo]

So again, I've asked you to post, type, exactly what you are putting in and you haven't, so it is very hard to help you without that information.

What region are you in, some regions don't use the comma as a separator some use a semi-colon, you could try and replace any instances of a comma with a semi-colon and see if that works.

As well, please let us know what version of Excel you are using, that is in addition to your region.

 

[mumps]

I don't see the file in the link.

 

[Rick Rothstein]

Does this formula work for you...

=TRIM(RIGHT(SUBSTITUTE(A1,"=",REPT(" ",300)),300))