Need to extract part of a cell that's an alphanumeric (minus sign with number/alpha value)

Hello Everyone..

I have a cells containing text streams (example in A1: Made in China 12345367658-01 Chemical XYZ 200 G/l )

I want to extract the " -01 " portion of the cell only.

The alphatext string can vary both pre and post the "-01".

Is there a smart / easy one step way in which to extract the -01 value (note the value can be -02, -A3, -1A etc..., but never more than 2 digits long and its always post the "-" (minus) sign).

I am after a function, cell formula rather than a macro

Hope that's clear, any help much appreciated...

Thanks
Jaybo

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

Chris

Or
=MID(A1,FIND("-",A1),3)

if you need the "-"

Chris

A great big thank you to you both... You have saved me loads of time & hassle in trying to figure this out.