pattern matching possible?

  • Thread starter Thread starter vito
  • Start date Start date
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?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Coronavirus Cure 12
SUMIF with criteria "<>" & "=" 4
can a cell be both input and output? 2
Drop down menu 1
Need an expression that's larger than my skill 5
Is it possible to match a cell's contents from a list ? 4
using the =page! feature to transpose a row to column 0
vlookup multiple data 11

Back
Top