I did this... It's not simplest solution but couldn't do better

Main problem is because it's everything in one cell (C2:C5).
if you put text in separated cells it would be much simplier...

Sample(1).xls

Also, it would be easier if you use 2007.