Help with a formula to extract text

**SEMMatt** · 10-23-2012, 09:42 AM

Could anyone help me with a formula to extract the words Text Link which occurs after umedium=. It's always going to be surrounded by umedium= and &

?WT.mc_id=ABCD4567&source=ABCD4567&umedium=Text Link&uadpub=pub&ucreative=creative Link&ucampaign=my_campaign

Thanks,

**Marcol** · 10-23-2012, 09:53 AM

One way with your string in A2

Formula:

Please Login or Register  to view this content.

**NBVC** · 10-23-2012, 09:54 AM

Try:

=LEFT(MID(A2,FIND("umedium=",A2)+8,255),FIND("&",MID(A2,FIND("umedium=",A2)+8,255))-1)

assuming text in A2.

**johnjohns** · 10-23-2012, 09:54 AM

perhaps

Please Login or Register  to view this content.

Sorry!i Mine is the wrong answer! I did not read the post fully! Apologies!

**Marcol** · 10-23-2012, 10:09 AM

Another way with your string in A2

Formula:

Please Login or Register  to view this content.

Note that my first post is the same as NBVC, only I used LEN("umedium=") instead of the fixed value 8, there is no problem either way.
Just thought LEN("umedium=") might help to explain where 8 is derived from.