Thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Hankjam" ........ wrote in message
...
On Wed, 2 Jul 2008 16:00:35 -0700, "RagDyeR"
wrote:

Depending on how accurate your examples were, these might or might not
work
for you.

These are longer then what you tried because I added the possibility that
the data might have varying lengths.

With data starting in A1 and going down,

Enter this in B1 for the daughterboard number:

=MID(A4,FIND("board",A4)+6,6)


Enter this in C1 for the name of the kinase enzyme:

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


Enter this in D1 for the ATP concentration:

=MID(A4,FIND(" at ",A4)+3,FIND("ATP",A4)-FIND(" at ",A4))


Then select B1 to D1, and copy down as needed.

Hi Ragdyer

It surely does.

Many thanks

Yours

Andrew j