How about
datatext to columnsdelimitedspace

--
Don Guillett
SalesAid Software

"maryj" wrote in message
...
I have a list of people's names in a cell. Some examples a
Mr. John Doe
Mrs. Jane S. Smith
Ms. Cynthia Jones

I need to split their titles, first name with Middle initial and Last name
into 3 seperate columns. Using a post on this site, I was able to extract
the title, but am unsure how to pull the other information.

Thanks for you help!