pattern matching possible?

V

vito

A1 B1
Other translation proteins [ko00000] K03540 [RPR2]


extract ko00000 and K03540 from 2 cells.

Is it possible to achieve that in Excel?
 
B

Bob Phillips

What are the rules? The [ ]? If so

=MID(A1,FIND("[",A1)+1,FIND("]",A1)-FIND("[",A1)-1)

=MID(A1,FIND("]",A1)+2,FIND("[",A1,FIND("[",A1)+1)-FIND("]",A1)-2)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top