Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding cells of different string length. | Excel Discussion (Misc queries) | |||
String length | Excel Discussion (Misc queries) | |||
Limit to string length in search@replace? | Excel Discussion (Misc queries) | |||
SMALL() on unknown length of list | Excel Worksheet Functions | |||
fixed string length,even other record is copied | Excel Discussion (Misc queries) |