Extract Data from a string

[dcaraher]

I am using Excel 2007 and I have a workbook with 12 different sheets. I have attached a sample of the field I need help with.

I need to extract the City/Town out of the branch field. The only pattern I can spot is that each branch begins with a number which is up to 4 numeric characters long, followed by a space and then the first part of a City/Town. This is followed by a space and either the second part of the town or another piece of information which I don't need.

I appreciate any help anyone can give me, either a formulae or VBA.