i have a master list that has a persons names and titles in one cell.
i need to spllit these names and titles into columns.

the first word will always be the title e.g Dr. Mr. Miss,
the second word is the first name,
the last word is the last name.
any other names go into the middle name column
title, first name and last name always have to be there.
so if a name is Mr. jack Jones we will have no middle name but miss. jane
doe anne andrew. should have 2 middle names.

the usual text to columns option isnt very helpfull as am forced to follow
and do a clean up.
is there a naother way of doing it or could i please have a macreo for it.