Excel 2007 : Parse string of text from one cell

I have the path for some of my data in column A and it ends with a back slash "\". I have been trying to find a way to start at the right of a cell and backtrack to the second occurrence of this and extract the text up to right until you hit the next/last occurrence of it. I have attached a sample spreadsheet with sample data and the desired result.

I have spent a few hours trying to nail this one down and searched all the help and forums that I can find.

Any assistance would be greatly appreciated.