Excel 2007 : How to extract the period from a Year / Period text string

Hi,

I'm sure there's a simple explanation to this but i'm struggling. All i'm looking to achieve is to extract the period number from a year/period text string (see attached). I can obtain periods 1-9 by using the RIGHT formula but how can I obtain it for periods 10-12?

Thanks in advance,

Snook

=--mid(a2,6,2)