splitting text to multiple columns
 

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!

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!

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!

Chip has some extensive discussion.
http://www.cpearson.com


--
Don Guillett
SalesAid Software

"maryj" wrote in message
...
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!

In addition you might take a look at SepTerm and SepLastTerm
in http://www.mvps.org/dmcritchie/excel/join.htm
it's a matter of what your data actually is and I think this would
fit your situation. You will have to join names like de Bruin
first though like de_Bruin and the remove the underscore later.

Insert two new columns to the right of the name
first use the SepTerm macro
then use the SepLastTerm macro on the 2nd column.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Don Guillett" wrote...
Chip has some extensive discussion.
http://www.cpearson.com

"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 Dave. The macros worked perfectly!

"David McRitchie" wrote:

In addition you might take a look at SepTerm and SepLastTerm
in http://www.mvps.org/dmcritchie/excel/join.htm
it's a matter of what your data actually is and I think this would
fit your situation. You will have to join names like de Bruin
first though like de_Bruin and the remove the underscore later.

Insert two new columns to the right of the name
first use the SepTerm macro
then use the SepLastTerm macro on the 2nd column.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Don Guillett" wrote...
Chip has some extensive discussion.
http://www.cpearson.com

"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.