Excel 2003 Split an address with multiple street names

I have a street name say:
King Conrad Wilson Way.
If i use the left /right function I will get something like King in one column & Conrad Wilson Way in the other .
I imagine I would use a combination of FIND & MID functions to do this but am not quite sure how.
Help would certainly be appreciated.
Thanks