That would work except if the person has a middle initial listed, that needs
to stay with the first name, and not all people have a middle initial.

Thanks for the idea though.

"Don Guillett" wrote:

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!