Seperating First and Last name from combined

[CPiper]

I presently have a database of about 5,000 names that I
track. ColumnA is the clients name. The poblem that I
am having is that there really is no rhyme or reason to
how they were entered over the years. Some names are
entered with only a first and last name, some are entered
with a middle initial, some have the entire middle name.
Given all of this, has anyone written a macro that
extracts the first name, middle initial, and last name
and places them in three seperate cells? Is it possible
to accomplish this using the right and/or left worksheet
functions given the differences in the length of the last
name and the possible presence of a middle name? I would
appreciate someone pointing me in the right direction.

CPiper

 

[Andy Brown]

Given all of this, has anyone written a macro that

extracts the first name, middle initial, and last name
and places them in three seperate cells?

Chip.

http://www.cpearson.com/excel/FirstLast.htm

Rgds,
Andy

 

[RagDyer]

<Data> <Text To Columns>
Will do what you are looking for, place each name and/or initial into a
separate column.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I presently have a database of about 5,000 names that I
track. ColumnA is the clients name. The poblem that I
am having is that there really is no rhyme or reason to
how they were entered over the years. Some names are
entered with only a first and last name, some are entered
with a middle initial, some have the entire middle name.
Given all of this, has anyone written a macro that
extracts the first name, middle initial, and last name
and places them in three seperate cells? Is it possible
to accomplish this using the right and/or left worksheet
functions given the differences in the length of the last
name and the possible presence of a middle name? I would
appreciate someone pointing me in the right direction.

CPiper

 

[Andy Brown]

Hi RD.

<Data> <Text To Columns>

will do fine, as long as it doesn't matter whether the columns will get out
of synch where eg: no middle initials.

Rgds,
Andy