How do I separate the following file name using the formula?

Apr_27_2014_12_54_43_PM_Area3_West. S._12.xls

I want Area 3 in one column, West. S. in second column and 12 in third column. I know this is doable. I have seen the formula before but can't find that file to copy the formula.

Thank you so much!