Okay, I put your example data in A1:A3 and the following formulae in
the cells stated:

B1: =MID(A1,30,SEARCH(" ",A1,30)-30)

C1: =MID(A1,SEARCH(") for",A1)+6,SEARCH(" at ",A1)-SEARCH(")
for",A1)-6)

D1: =MID(A1,SEARCH(" at ",A1)+4,FIND(" ATP",A1)-SEARCH(" at ",A1)-4)

and this gave the answers you wanted.

Better to copy the formulae from here into your sheet, but if you type
them in take care with the spaces and be wary of spurious line-breaks
that sometimes occur on the newsgroups.

Copy B1:D1 down for as many items as you have in column A.

Hope this helps.

Pete

On Jul 2, 10:25*pm, 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