how to pull out a string a text in between of 2 other strings of text

Hey guys,

Could you provide some help with regards to how to pull out a string a text in between of 2 other strings of text. The two strings on either side are always the same.

For example: www.myurl.com/textleftside=ABCDE&textrightside=blah

I'm interested in pulling out the ABCDE which is in between textleftside and textrightside. I just can't remember the formula.


Thanks

If the = and & are consistently before and after then easier to use:

=MID(A2,FIND("=",A2)+1,FIND("&",A2)-FIND("=",A2)-1)

since the textleftside/rightside may be variable...

have you got a real string what character is immediately before and after the text you want to parse?

Try this

Formula:

Please Login or Register  to view this content.

---------- Post added at 10:31 AM ---------- Previous post was at 10:30 AM ----------

Beat me to it