Seperating First and Last name from combined

  • Thread starter Thread starter CPiper
  • Start date Start date
C

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
 
<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
 
Hi RD.
<Data> <Text To Columns>
Click to expand...

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
 
Back
Top