ExcelBanter - pattern matching possible?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - pattern matching possible? (https://www.excelbanter.com/excel-worksheet-functions/88896-pattern-matching-possible.html)

vito

pattern matching possible?

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

extract ko00000 and K03540 from 2 cells.

Is it possible to achieve that in Excel?

Bob Phillips

pattern matching possible?

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)

"vito" wrote in message
...

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

extract ko00000 and K03540 from 2 cells.

Is it possible to achieve that in Excel?

All times are GMT +1. The time now is 02:21 PM.