Text to column macro

[Guest]

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.

 

[Paul B]

Anthony, see if this will help you,
http://www.cpearson.com/excel/FirstLast.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

thanks lot am checking it out right away.