MID and FIND question

**HelsinkiMatadors** · 10-23-2011, 10:50 PM

So I have a column of long text strings that essentially are made up of '&'s followed by an alphabetic code, and then an '=', and finally, a bunch of numbers (varying lengths).

here is a sample:

...&abc=123435&defg=54321&hijklmno=14&...

I want to extract from the sample above the following:

defg=54321

I know Im always extracting defg=, but I do not know where it is in the cell, and I do not know how many numerals come after the = and before the following &.

Any ideas??

**alansidman** · 10-23-2011, 11:18 PM

Is there always an & after the numbers following defg?

Alan

**veejar** · 10-23-2011, 11:40 PM

hi

Try this code and check whether it works.
Put the Code in B1 and assuming that Column A has your data

Code: =MID(A1,SEARCH("defg=",A1,1),10)

**alansidman** · 10-23-2011, 11:45 PM

I have attached a solution. I used helper columns so that you could see how each piece comes together. You can combine the columns to make one long formula if you like.