One more--with the data in A1:

=MID(A1,30,6)
=MID(A1,57,SEARCH(" at ",A1)-57)
=MID(A1,SEARCH(" at ",A1)+4,SEARCH(" atp concentration",A1)-SEARCH(" at ",A1)-4)

If you want the concentration to be a real number (not text):

=--MID(A1,SEARCH(" at ",A1)+4,
SEARCH(" atp concentration",A1)-SEARCH(" at ",A1)-4)

(Format that cell to show the number of decimals you want.)



Hankjam wrote:

Hi

I've tried variations on MID, FIND, LEN, LEFT and Right and still not
able to do this.

I have strings that can be 89, 90, 91 or 92 characters long and
sometimes more.

I want to find the name of an enzyme in this string that can vary to
between 5 and 12 characters.

Something like this:

Plate Plan for Daughterboard 286338 (05_jul08_0036) for XXX(h) at 12.0
ATP Concentration
Plate Plan for Daughterboard 286338 (05_jul08_0036) for XXXX(h) at
100.0 ATP Concentration
Plate Plan for Daughterboard 286338 (05_jul08_0036) for XXXX(h) at
45.0 ATP Concentration

I want to list in separate cells:
1) the number of the Daughterboard (286338)
2) the name of the kinase (XXX(h))
3) The ATP concentration

and I don't want to column pharse, if that is the right term.

Many thanks for your time

Andrew j

--

Dave Peterson