| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Otto M. - Data Matching | Excel Worksheet Functions | |||
| Auto-generating a list of records that meet a pattern criteria | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Show a grid pattern not corresponding to the cell sizes | Excel Discussion (Misc queries) | |||
| Count matching cells | Excel Worksheet Functions | |||
Linear Mode
