Hello RD

You were kind enough to help me out on a string finding exercise.

The example was something like "Plate Plan for Daughterboard 286338
(05_jul08_0036) for XXXX(h) at 100.0 ATP Concentration"

and you came up with:

=MID(SUBSTITUTE(A4,"for","^^",2),FIND("^^",SUBSTIT UTE(A4,"for","^^",2))+3,
FIND("(h)",A4)-FIND("^^",SUBSTITUTE(A4,"for","^^",2)))

which in nearly all worked a complete treat.

I have there kinases which have a ", activated" after the
kinase_name(h) and the string only finds the first part.

"Plate Plan for Daughterboard 286338 (05_jul08_0036) for XXXX(h),
activated at 100.0 ATP Concentration"

Two questions:

Can you explain to me how the above works?

and

can it be adapted for a kinase name with a space in it?

Many thanks for the time you've already spent on this.

Yours

Aj