Excel 2007 : How to split text, number and a letter into 3 columns?

I have read every single thread in internet and this forum and haven't found any answer to this question.
I have a large list of companies with their addresses, for example:

High Mountain 3
Little Italy 445
West Virgina 23 a

I would like to split them apart to get every part of the address into 3 columns (West Virginia / 23 / a). The problem is that I can't use functions LEFT, RIGHT or MID because the length of the words is different.

Thanks for your solutions!