How to parse data from a cell

[santa12345]

Hello.

What formula would I use to parse the following.

JC-RO-06-L367-E201-J166-MK5C40-M14XT

The number could and can be different, but the section I'm looking for the characters following the MK.
So in this example I would want the formula to return 5C40.

Another example:

JC-RO-06-L367-E201-J166-MK5C4011-M14XT
So in this example I would want the formula to return 5C4011

Bottom line - the text after the MK and before the - .

Thank you.... hopefully this makes sense.

 

[Rick Rothstein]

When you say you "need to extract the RO", I am assuming you mean the next number after it between the dashes, correct? If so...

=MID(LEFT(A2,FIND("-",A2,7)-1),7,99)

 

[Peter_SSs]

Always a good idea to provide enough sample to show any variety that might occur with your data.

So, what about you give us 5 or 6 varied samples and the expected results instead of just one?